We try to connect to a Teradata database using ODBC.
With the SQL Assistant we can establish a connection. But if we try to connect with our own application we get the following error message:
Can not connect: 444 "HY000 [Teradata][ODBC Teradata Driver][Teradata Database] Unicode Conversion Error01000 The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 03.80 HY000 [Teradata][ODBC Teradata Driver][Teradata Database] Unicode Conversion Error"
I didn't find an explanation in the documentation.
What session character set did you specify for the connection?
Are the username / password, default database, etc. values being presented to the database in that same character set?
ODBC trace might be useful to determine exactly where the failure is occurring.
The session character set is ASCII in ODBC configuration.
I have a look in the database and columns like DefaultDatabse are Unicode.
It would seem that the data in the logon string / parameters does not match the application code page for some reason.
I'd suggest reviewing the "International Character Set Support" section of Chapter 8 in the ODBC Driver for Teradata manual.