I changed my encoding from SQL_ASCII to UNICODE.
I believe the Unicode is supposed to support more languages?
Any how the ODBC driver does not appear to support setting the encoding?
I was able to use the .net driver and get the same error, and then add the encoding=Unicode to the connection string and save ok, but we have many asp pages where I will need the odbc not the .net driver.
Any one have a work around or am I totally missing something?
I tired a SQL statement SET client_encoding= 'UNICODE'; just to see if it helped, but no dice.
Joel Fradkin