Help:Octofy: Manage data sources
Change the settings of a data source
To manage the data sources you added to the system, click on the Manage DB connections menu item from the File menu. The Manage Connections Dialog will pop up.
- Select the data source item in the Connections list box.
- Edit and change the name of the data source in the Name text box.
- Enter the server name in the Server name text box if you want to connect to a different database server.
- Enter or select database name from the Database name combo box.
- Select the authentication type to log on to the server
- Enter User name and password if SQL Server Authentication has been select.
- Check the Remember password check box if you want the system to remember the password.
Connection to a SQL server using a different port
If the target SQL server using a different port other than the default 1433, you can type the server name into the Server name text box follows by a comma then the port number. For example mydb.database.windows.net,14330 where mydb.database.windows.net is the database server name and 14330 is the port number.
Add a new data source
You can add a new data source from this dialog as well. To add a new data source, click on the New button and repeat the steps as same as #Change the settings of a data source
Delete a data source
To delete a data source:
- Click on the data source item in the Connections list box.
- Click on the Delete button
- Click on the OK button to confirm the deletion.
Test a data source connection
You can select a data source item from the Connections list box and click on the Test button to ensure the database connection works.
Back to Octofy User Manual
