Kbase P151890: How to create a system DSN for MS SQL Server?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/08/2009 |
|
Status: Unverified
GOAL:
How to create a system DSN for MS SQL Server?
GOAL:
How to create a system DSN to connect to MS SQL Server database?
FACT(s) (Environment):
Windows
Progress 9.1x
OpenEdge 10.x
FIX:
Following the steps below to create a system DSN on Windows XP or higher:
1. Start > Settings > Control Panel > Administrative Tools > Data Sources (ODBC)
2. In the "ODBC Data Source Administrator" windows, click on the System DSN
3. Click Add, and scroll down to the bottom of the driver list on the "Create New data Source" window
4. Select SQL Server driver from the list
5. On the "Create a New Data Source to SQL Server" window, enter name for the ODBC DSN, Description is optional and type the SQL Server host name or click the down arrow to get a list of MS SQL Server host name(s). If the MS SQL Server is on the localhost, type "(local)" on the server without the double quotes, and click Next
6. Choose the appropriate authentication to connect to MS SQL Server Database and click Next.
NOTE: With Windows authentication you do not require User name and password but the MS SQL Server needs to be running on Windows authentication mode or Both Windows authentication mode as well as the MS SQL Server authentication mode in order to use Windows authentication mode. If you are given a user name and a password, you need to choose SQL Server authentication.
7. Place a check on the "Change the default database to:" and choose the correct database by clicking the down arrow selection list, and click Next and then click Finish on the last screen.
8. Click the "Test data Source..." button to make sure the connection is successful and click OK.
At this point a system DSN is created successfully.