Kbase P184190: Cannot connect to database with ODBC client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/03/2011 |
|
Status: Unverified
SYMPTOM(s):
Cannot connect to database with ODBC client
HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Server rejects connection on attach.
ERROR [08S01] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Socket closed.
ERROR [HYC00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Optional feature not implemented.
ERROR [IM006] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Driver's SQLSetConnectAttr failed.
ERROR [01S00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Trusted_connection.
ERROR [01S00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Max Pool Size.
ERROR [01S00] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Min Pool Size.
Using a file DSN
ODBC connections to the same database work from other clients
FACT(s) (Environment):
Windows
OpenEdge 10.1B
CAUSE:
The file DSN has the wrong entry for database name:
<DATABASE>Wrong database name</DATABASE>
FIX:
Change the database name to the actual database name in the file DSN:
<DATABASE>database name</DATABASE>