Difference between revisions of "Help:Octofy: Add data source"
From Sherlock Software
m |
|||
| Line 1: | Line 1: | ||
[[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]] | ||
==Add data source== | ==Add data source== | ||
To add a data source, click on the "Connect to..." menu item from File menu or click on the "+" button on the toolbar. The "New SQL Server Connection Dialog" will pop up. | To add a data source, click on the "Connect to..." 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 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 8: | Line 8: | ||
**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 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,1234" where mydb is the database server name and 1234 is the port number. | |||
Back to [[Help:Octofy: User Manual|Octofy User Manual]] | Back to [[Help:Octofy: User Manual|Octofy User Manual]] | ||
Revision as of 16:55, 27 September 2021
Add data source
To add a data source, click on the "Connect to..." 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,1234" where mydb is the database server name and 1234 is the port number.
Back to Octofy User Manual
