Kbase P178276: 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 |
12/8/2010 |
|
Status: Unverified
GOAL:
How to link Progress Database to the MS SQL Server 2008 using Data Direct sql-92 ODBC Driver?
GOAL:
How to make a linked server of Progress Database in MS SQL Server 2008?
GOAL:
How to access Progress database from SQL server 2008?
GOAL:
How to connect to Progress database from SQL server 2008?
FACT(s) (Environment):
Progress/OpenEdge Versions
MS SQL 2008
All Supported Operating Systems
OpenEdge SQL Category: ODBC Drivers
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 Microsoft SQL Server Management Studio and select the connect button on the popup.
3. Under the Server Objects folder, select the Linked Servers folder and right mouse click on the linked server folder and select New Linked Server.
4. Provide the information as follows under the general section:
-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 section, 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.