KB217257: "Invalid Session Character Set" error is seen when attempting to establish connection to Teradata in MicroStrategy 9.x or 10.x

• Strategy

This document describes an error that can occur when trying to establish connection to a Teradata database in MicroStrategy 9.x or 10.x.

SUMMARY
This document describes an error that can occur when trying to establish connection to a Teradata database in Strategy 9.x or 10.x. The issue occurs when the “CharacterSet” parameter in the odbc.ini file is not configured correctly.

SYMPTOM
In Strategy 9.x or 10.x. the following error is seen when attempting to establish connection to a Teradata database:


Connect failed.
Error type: Odbc error.  Odbc operation attempted: SQLDriverConnect. [HY000:0: on SQLHANDLE][Teradata][ODBC Teradata Driver] Invalid Session Character Set [28000:0: on SQLHANDLE][Teradata][ODBC Teradata Driver] Not enough information to log on

CAUSE
In this case the error was due to an invalid entry in the “CharacterSet” parameter in the odbc.ini file.

The valid entries for the “CharacterSet” parameter for Teradata are below:

blank (default for KanjiFormat)
ASCII (for SBCS)
UTF8
SCHEBCDIC935_2IJ, TCHEBCKIC937_3IB
TCHBIG5_1RO, SDTCHBIG5_3RO
SCHEGB2312_1TO, SDSCHGB2312_2TO
SDSCHEBCDIC935_6IJ, SDTCHEBCDIC937_7IB
SDKANJIEBCDIC5026_4IG, SDKANJIEBCDIC5035_4IH
SDKANJIEUC_1U3, SDKANJISJIS_1S3
HANGULEBCKIC933_1II, HANGULKSC5601_2R4
SDHANGULEBCKIC933_5II, SDHANGULKSC5601_4R4
KANJISJIS_OS, KANJIEUC_OU

ACTION
Specify a valid character set in the “CharacterSet” parameter in the odbc.ini file.

Comment

0 comments

Details

Knowledge Article

Published:

May 30, 2017

Last Updated:

May 30, 2017