Be sure you have installed proper TDICU and TeraGSS libraries also.
hi Fred, one of my team members is facing the same situation right now. Our team uses Teradata ODBC driver in Business Objects reports. The situation came up when she was trying to pull a Business Objects report.The "Catalog error" prompt shows up only when Business Objects alone is being used. If she just logs in to Teradata and then opens the report in Business Objects, then, there is no catalog error.I understand that the issue is with the ODBC driver. Can you help me in fixing this? Whom should I consult or what should I do now?Any suggestion is greatly appreciated.Thank you
"[ODBC Teradata Driver] Unable to get catalog string."This error indicates that Teradata ODBC driver trying to post an error, but it cannot find it's error message catalog file.Search for "tdodbc.cat" file and set NLSPATH variable. For example if you find tdodbc.cat in/opt/teradata/client/lib/odbc/tdodbc.catthen setNLSPATH=/opt/teradata/client/lib/odbc/%N.cat---It would let you see the actual error message.
Status Code: 8140 Connecting to ODBC. Unable to populate section table sect1.error IM002 Microsoft ODBC DRiver Manager Data Source name not found and no default drive specified
I am getting the following error when trying to connect to Teradata from UNIX (Sun OS). This connection was working couple of weeks back and stopped working after the server crashed due to user libraries were deleted (do not know how). I am trying to connect using ODBC entry and below is how my ODBC is setup. ---------------------------[tdp1_ip]Driver=/usr/odbc/ drivers/tdata.soDescription=Dev TeradataDBCName=10.206.68.19DateFormat=AAASessionMode= ANSIDefaultDatabase=UserName=Password=---------------- -----------I am using to test my odbc connection. Below is the error message: -----------------------------------./demoodbc DataDirect Technologies, Inc. ODBC Sample Application../demoodbc: will connect to data source 'tdp1_ip' as user 'user1/passwd1'.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.SQLConnect: Failed...SQLSTATE = S1000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLSTATE = 28000NATIVE ERROR = 0MSG = [NCR][ODBC Teradata Driver] Unable to get catalog string.SQLConnect: Retrying Connect.No connection could be established. ----------------------------------------Any help on this is greatly appreciated. Thanks,