Error message: ODBC connection

Connectivity

Error message: ODBC connection

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.

Tags (2)
3 REPLIES
Highlighted
Teradata Employee

Re: Error message: ODBC connection

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.

Re: Error message: ODBC connection

The session character set is ASCII in ODBC configuration.

I have a look in the database and columns like DefaultDatabse are Unicode.

Teradata Employee

Re: Error message: ODBC connection

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.