odbc/ sql server linked server connection problem

Connectivity

odbc/ sql server linked server connection problem

We are using the SQL Server 2000 linked server functionality (openquery) from stored procedures to get data from teradata through the odbc driver 3.06.
We tried an upgrade to TTU 12.0 and no relief.
We can duplicate this by running stored procedures in rapid succession that access this linked server.

We get this error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. Authentication failed.
[OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Not enough information to log on]
[OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Cannot find a compatible package match between client and gateway in terasso library.]
[OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-The operation completed successfully.
]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Invalid connection string attribute]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]
[OLE/DB provider returned message: [NCR][ODBC Teradata Driver] Major Status=0x04b6 Minor Status=000000-No Routine error/No calling error]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].

Anyone have any ideas?
We can't seem to get a trace of a failure which isn't helping much. We can trace ODBC when connecting via vb script but not through linked server.
1 REPLY
Teradata Employee

Re: odbc/ sql server linked server connection problem

Does the ODBC driver work outside of SQL Server?
Did you install the corequisite Teradata GSS component along with the driver?
Do you have more than one copy of terasso.dll installed, in different paths? If so, be sure the correct one is in %WINDIR%\System32 and remove / rename the others.

You could also consider using the Teradata OLE DB Provider (TDOLEDB).