I want link an Progress server on my SQL server 7. Some msg err apear when I try see the Tables on the linked server. I have try with the ODBC source with the stringconnection:"DRIVER={MERANT 3.60 32-BIT Progress SQL92 v9.1D};UID = USER;PWD=UserPW;DB = TEST;Port = 18200;HOST = nt05"
The msg that apear is:Error 7302: Could Not create an instance of Ole DB provider 'MSDASQL'"Try this:
Set up an ODBC System DSN on your machine, we'll call it NT05. Test it to be sure it can connect successfully.
Add a new linked server, and select the Microsoft OLEDB Provider for ODBC Drivers as the Provider name.
Product Name: MERANT 3.60 32-Bit Progress SQL92 v9.1D
Data Source: NT05
Provider String:
Location:
Catalog: TEST
On the Security tab, select the "Be made using this security context:" option.
Remote Login: USER
With password: UserPW
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment