Kbase P135637: Connection to ODBC DSN failed when querying Access Database on the linked table from a different dat
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/14/2008 |
|
Status: Unverified
SYMPTOM(s):
Connection to ODBC DSN failed when querying Access Database on the linked table from a different database using ODBC DataServer
S1000: [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'DSN-name' failed.
FACT(s) (Environment):
The above error is displayed when querying Access database on a linked table from FoxPro Database
The Access Database is remote to the ODBC DataServer machine
The Access Database has a link table from FoxPro Database
The DSN name displayed on the above error is for FoxPro Database
Microsoft Excel also showed the same error when MS query is used to pull the records to Excel
Recreating the Access DB and relinking the Foxpro DB resolve the issue
Windows
Progress 9.1x
OpenEdge 10.x
ODBC DataServer
CAUSE:
The exact cause is unknown at the time of this writing
FIX:
Recreate the Access database, and relink the Foxpro database on the same machine. The Access DB is still remote from the ODBC DataServer machine.