Kbase 21702: Invalid attribute in connection string - Merant ODBC 219901
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.1x
Windows 32 Intel
SYMPTOM(s):
[MERANT][ODBC PROGRESS driver]Invalid attribute in connection string: description MERANT ODBC Progress driver Progress 219901
SQL-92 ODBC Driver Error 219901 when attempting to connect to a database.
Connection from SQL Explorer, SQL-92 JDBC Driver, works.
Database codepage and -cpinternal is set to ISO8859-1.
Running windows operating system with regional settings such as simplified Chinese
CAUSE:
The Operating Systems regional settings do not match the database's defined code page.
FIX:
Add this variable SQL_CLIENT_CHARSET to the system environment, and set its value equal to database server code page (-cpinternal).
For example, when running a Database with -cpinternal iso8859-1 and with an OS regional setting set to Czech (French ...), set SQL_CLIENT_CHARSET equal to ISO8859-1.