Kbase P135145: How to configure a remote DSN for Access database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/09/2008 |
|
Status: Unverified
GOAL:
How to configure a remote DSN for Access database?
GOAL:
What are steps to configure a data source to connect to remote Access Database?
FACT(s) (Environment):
Windows
Progress 9.x
OpenEdge 10.x
ODBC DataServer
FIX:
First, map a network driver from the remote machine where the database resides to the machine DSN is set up
Second, in ODBC data source, select MS Access driver, go to Configure, enter Data Source name, click Select button, in the database Selection dialog, select the database file on the mapped drive. Click OK
There is no "Test connect" option for this driver, any ODBC based testing utility such as winSQL can be used to test this DSN