Kbase P27768: What is the ODBC Data Source Administrator basic configuration for an ODBC DSN using the SQL92 drive
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/2/2009 |
|
Status: Verified
GOAL:
What is the ODBC Data Source Administrator basic configuration for an ODBC DSN using the SQL-92 driver
GOAL:
How to use Microsoft's ODBC Data Source Administrator to configure a DSN for SQL-92
GOAL:
How to configure a SQL-92 DSN
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
FIX:
Start up the ODBC Data Source Administrator(found in Control Panel within the Administrative Tools folder)
Example:
1. Select the System DSN tab
2. Select the Add button to the right
3. Select the MERANT 3.60 32-BIT Progress SQL-92 9.1D driver for setting up under 9.1D
note: or the appropriate driver for your version of Progress.
4. Select Finish
That brings up the configuration screen for a new DSN.
Fill-in the following information:
1. Data Source Name..... (whatever you choose)
2. Description.......(optional and whatever you think is appropriate)
3. Host Name......(the server where the database is located)
4. Port Number.... (the port your database broker was started with...if multiple
brokers..the SQL broker port)
5. Database Name....(database name you wish to connect to)
6. User ID...(the user you logged in with or if security is turned on..a user
that can connect to the database)
7. Leave all other tab settings at the defaults for the initial configuration.
8. Select the Apply button.
9. Select the Test Connect button.
10. Screen requesting a password pops up. (enter one only if the database
normally requires a user name and password from the 4GL side to enter the database)