Kbase P27210: Can a SQL92 ODBC client connect to a Personal Database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
Can a SQL92 ODBC client connect to a Personal Database?
GOAL:
Can a local SQL92 ODBC client connect to a Personal Database?
GOAL:
Can a remote SQL92 ODBC client connect to a Personal Database?
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92 9.1D
Progress 9.1x
FIX:
A SQL92 ODBC client can connect to a Personal Database, provided the Personal Database:
- starts a broker process using the client/server connection parameters -N, & -S and
- the SQL92 ODBC client connection is made locally to the Personal Database (on the same machine using the same client/server connection parameters -N, -H & -S).
A remote SQL92 ODBC client (one who is located on a different physical machine) can NOT make an SQL92 ODBC client connection to a Personal Database.
Note: the -H parameter must be localhost, not the hostname of the server.