PDA

Click to See Complete Forum and Search --> : ODBC connection string : specifying codepage?


Merrion
Mar 21st, 2005, 09:13 AM
Anyone know how (or if it is possible) to specify the code page to use in a Sybase ODBC connection string i.e. how do I alter:-

DRIVER={Sybase System 11};SRVR=WARSAW1;UID=readonly;PWD=readonly;DATABASE=Poland

to prevent the error message:-
ERROR [HY000] [INTERSOLV][ODBC SQL Server driver][SQL Server]Character set conversion is not available between client character set 'cp850' and server character set 'cp852'.
ERROR [01000] [INTERSOLV][ODBC SQL Server driver][SQL Server]No conversions will be done.
ERROR [HY000] [INTERSOLV][ODBC SQL Server driver][SQL Server]Character set conversion is not available between client character set 'cp850' and server character set 'cp852'.
ERROR [01000] [INTERSOLV][ODBC SQL Server driver][SQL Server]No conversions will be done.

Thanks in advance,
Duncan