MS ACCESS CONNECTIVITY ISSUE TO TERADATA DATABASE

Database

MS ACCESS CONNECTIVITY ISSUE TO TERADATA DATABASE

hello everyone,
great forum.
I am trying to connect to TERADATA via AN IP address using MS ACCESS.
However although ODBC is configured as per the requirements I keep getting this error message
ODBC 28000: Not enough information to log on
ODBC IM009: Fail to load TranslationDll.

I know the ODBC version is compatible as a colleague with the same config was able to connect,
It only applies to my PC.

Any help is great help
Su

2 REPLIES
Teradata Employee

Re: MS ACCESS CONNECTIVITY ISSUE TO TERADATA DATABASE


Is it possible that your ODBC DSN for Teradata was configured with a tranlation dll? Check the ODBC DSN under advanced settings.

Re: MS ACCESS CONNECTIVITY ISSUE TO TERADATA DATABASE

Hello,
Thank you for your reply.
I checked there are options to select the appropriate TRANSLATION DLL. However I don't know which one to select for MS ACCESS.

I found a user manual for ODBC set up on Teradata which I am currently going through.
Hopefully the answers will be stated.

Cheers
Su