Connecting to SQLA9 with SQLA11 drivers...

[Former Member]

I'm attempting to connect to a 3rd-party database. They're using SQLA9. At one time, I was able to connect with the SQLA10 drivers without a problem. Unfortunately, I cannot find the distributables for SQLA10 and had to use the SQLA11 drivers when the customer's machine got reimaged. All connection properties are the same and nothing has changed on the 3rd-party database/server side. Yet when I connect, I get an error:

SQLCode:    -1
DB Code:    -868
Error:  SQLSTATE = S1000
[Sybase][ODBC Driver][SQL Anywhere]'UTF-8' is an unknown character set label

[Former Member]

I don't specify the character set in my connection. I'm at attempting to explicitly set one using the CS connection property, but I'm flying blind.

[Former Member]

My crisis is over. I found my copy of the SQLA10 drivers and the user is up and running. This stated issue, though, is NOT solved.

[Former Member]

Even though you've resolved the problem, this might help:

UTF8 collation was deprecated in SQL Anywhere 10.0.0. This new collation is UTF8BIN. Not sure if specifying CS=UTF8BIN will work, but it's worth a try.