Kbase P94015: Getting error 17 when trying to access progress tables from sql server's linked server
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/09/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
FACT(s) (Environment):
MS SQL 2000
SYMPTOM(s):
Getting error 17 when trying to access progress tables from sql servers linked server
Error 17: SQL Server does not exist or access denied
Can not see list of tables under linked server
Linked Server configured to use Provider: Micrsoft OLE DB Provider for SQL Server
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Create a new linked server entry and use Provider Micrsoft OLE DB Provider for ODBC Drivers.
1. Right click on Linked Server folder
Under General Tab
2. Select New Linked Server
3. Enter any name for "Linked Server:"
4. Use toggle "Other data Source" with Provider; Micrsoft OLE DB Provider for ODBC Drivers
5. Enter any name for "Product name:"
6. Enter your configured ODBC DSN name under "Data source:"
Under Security tab
7. Select toggle; Be made using this security context:
8. Enter defined progress userid and password under "Remote login:: and "With password:" fields. Do not use user "sysprogress" for a remote login.
For further details on how to configure a linked server, please refer to Solution P22728, "How to link Progress Database to the MS SQL Server using SQL-92 ODBC Driver"