Kbase P22728: How to link Progress Database to the MS SQL Server 2000 using SQL-92 ODBC Driver
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/29/2008 |
|
Status: Verified
GOAL:
How to link Progress Database to the MS SQL Server 2000 using Data Direct sql-92 ODBC Driver?
GOAL:
How to make a linked server of Progress Database in MS SQL Server 2000?
GOAL:
How to access Progress database from SQL server 2000?
GOAL:
How to connect to Progress database from SQL server 2000?
FACT(s) (Environment):
Progress/OpenEdge Versions
MS SQL 2000
All Supported Operating Systems
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 2000 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 going to be the name of the DSN created in the system DSN using MERANT SQL-92 ODBC Driver.
The rest of the attributes can be left blank
4. 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 SQL92 user as supplied in the ODBC DSN.
5. Click OK, this will bring all the tables including progress system tables in the SQL Server 2000 Database.