Difference between revisions of "Help:Octofy: Add data source"
From Sherlock Software
| (7 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[Category:Octofy]] | |||
==Add data source== | |||
[[File:Octofy_Add_data_source.png|400px|thumb|right|Add data source screen]] | [[File:Octofy_Add_data_source.png|400px|thumb|right|Add data source screen]] | ||
To add a data source, click on the <strong>Add new DB connection</strong> menu item from the <strong>File</strong> menu or click on the <strong>+</strong> button on the toolbar. The <strong>New SQL Server Connection Dialog</strong> will pop up. | |||
To add a data source, click on the | |||
*Enter the server name in the Server name text box. | *Enter the server name in the Server name text box. | ||
*Enter or select database name from the Database name combo box. | *Enter or select database name from the Database name combo box. | ||
| Line 7: | Line 8: | ||
*Enter User name and password if SQL Server Authentication has been select. | *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. | **Check the Remember password check box if you want the system to remember the password. | ||
*Click the OK button the complete adding a data source. | *Click the <strong>OK</strong> button the complete adding a data source. | ||
===Connection to a SQL server using a different port=== | ===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, | 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 "<strong>mydb.database.windows.net,14330</strong>" where <strong>mydb.database.windows.net</strong> is the database server name and <strong>14330</strong> is the port number. | ||
</br> | |||
---- | |||
Back to [[Help:Octofy: User Manual|Octofy User Manual]] | Back to [[Help:Octofy: User Manual|Octofy User Manual]] | ||
Latest revision as of 03:53, 4 October 2021
Add data source
To add a data source, click on the Add new DB connection menu item from the File menu or click on the + button on the toolbar. The New SQL Server Connection Dialog will pop up.
- Enter the server name in the Server name text box.
- 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.
- Click the OK button the complete adding a data source.
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.
Back to Octofy User Manual
