Not enough information to log on

Connectivity

Not enough information to log on

Dear All,

    I need to connect to TD by ODBC. But It didn't work after I installed ODBC and configured it. The detail message is as below:

TD Server Version:13.10

Client OS:Red Hat 

[dsadm1@localhost example]$ uname -a

Linux localhost.localdomain 2.6.18-53.el5 #1 SMP Wed Oct 10 16:34:19 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

TTU Version :13.10

TPT Version :13.10

my odbc.ini file(ps:DBCName:s10-1310 is exists in /etc/hosts):

[TDDEMO2]
Driver=/opt/teradata/client/13.10/odbc_64/lib/tdata.so
Description=Teradata running Teradata V1R5.2
DBCName=s10-1310
LastUser=
Username=
Password=
Database=
DefaultDatabase=

My LD_LIBRARY_PATH:

/opt/teradata/client/13.10/tbuild/lib64:/opt/teradata/client/13.10/lib64:/opt/teradata/client/13.10/odbc_64/lib:/usr/lib

When I test the connection by adhoc, it return error message:

[dsadm1@localhost C]$ ./adhoc

Enter Data Source Name: tddemo2
Enter UserID: dbc
Enter Password: dbc

Connecting with SQLConnect(DSN=tddemo2,UID=dbc,PWD=*)...

adhoc: (SQL Diagnostics) STATE=28000, CODE=0, MSG=[Teradata][ODBC Teradata Driver] Not enough information to log on

ODBC connection closed.

Does any one how to resovle it? Thanks ...

Tags (1)
1 REPLY

Re: Not enough information to log on

Did you resovle this problem? It trouble me for a long time.

My OS is CentOS 6 ,

ODBC version: tdodbc-14.00.00.02-1.noarch

the  error message is the same to you.