Kbase P84589: How to link Progress Database to the MS SQL Server using SQL-89 ODBC Driver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/06/2004 |
|
Status: Unverified
GOAL:
How to link Progress Database to the MS SQL Server using SQL-89 ODBC Driver
GOAL:
How to make a linked server of Progress Database in MS SQL Server
FIX:
Follow steps below to accomplish this:
1. Setup an ODBC connection to the Progress Database in the ODBC Administrator in the System DSN. Make sure the connection successfully establishes.
2. Go to the Enterprise Manager in the MS SQL Server and under the security folder, select the linked server. Right mouse click on the linked server to select or create a new one.
3. Provide the information as follows:
- "Link Server" name can be anything.
- Under "Server type", choose "Other data source", and choose the
provider name as "Microsoft OLE DB provider for ODBC driver".
- Under the product name, it could be anything but better to use
"Progress" since it is a Progress database.
- "Data source" should be the name of the DSN created in the
system DSN using MERANT SQL-89 ODBC Driver.
- "Provider String" should be "MSDASQL".
The rest of the attributes can be left blank
4a. If the Progress database has security enabled:
- Go to the Security tab.
- Choose the radio button associated with
"Be made using this security context" and enter the
"Remote login" and "With password" of the Progress
SQL-89 user as supplied in the ODBC DSN.
4b. If the Progress database has NO security enabled:
- Go to the Security tab.
- Choose the radio button associated with
"Be made without using a security context"
- Make sure that "Security Required" is unchecked in Advanced tab
of the the ODBC DSN.
5. Click OK, this will bring all the tables including Progress system tables in the SQL Server Database.