ODBC Set up

[suneelchallagali]

Hi,

For first time we are setting up the ODBC connection, i have entered the values in .odbc.ini and uvodbc.config files under $DSHOME directory.
When i am trying to import table defination iam getting following error message

"DSR.MetaGeta(GET.DSNINFO)(SQLConnect('Teradata_Test','TDSPMS01')) : BCI Error :
SQLSTATE=IM003,CODE=0,[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Specified driver could not be loaded "

Here are the entries.

System Informatio:

[root@arlspmat41 DSEngine]# uname -a
Linux arlspmat41 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:48 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux




ODBC Connection:

[Teradata_Test]
Driver=/info_server/IS/Server/branded_odbc/lib/VMtera23.so
Description=DataDirect Teradata
AccountString=
CharacterSet=ASCII
DBCName=Teradata_Server_Name
Database=Teradata_DB_Name
EnableDataEncryption=No
EnableLOBs=Yes
EnableReconnect=No
IntegratedSecurity=No
LoginTimeout=20
MapCallEscapeToExec=No
MaxRespSize=8192
Password=DB_Password
PortNumber=1025
PrintOption=N
ProcedureWithSplSource=Y
ReportCodePageConversionErrors=0
SecurityMechanism=
SecurityParameter=
ShowSelectableTables=Yes
UserID=DB_User_Name

<Teradata_Test>
DBMSTYPE = ODBC


[DB2_Test]
Driver=/info_server/IS/Server/branded_odbc/lib/VMdb223.so
Description=DataDirect DB2 Wire Protocol Driver
AddStringToCreateTable=
AlternateID=
Collection=OS/390 and AS/400 (Remove for DB2 UDB)
Database=DB2_DB_Name
DynamicSections=100
GrantAuthid=PUBLIC
GrantExecute=1
IpAddress=DB2_Server_Name
IsolationLevel=CURSOR_STABILITY
Location=OS/390 and AS/400
LogonID=DB2_User_Name
Password=DB2_Password
Package=DB2 package name
PackageOwner=
TcpPort=3700
WithHold=1

<DB2_Test>
DBMSTYPE = ODBC

please help me to solve this issue. I have already search in this form most of them suggested issue will be solved once we properly entered the values into .odbc.ini and uvodbc.config files

thank you,
suneel

[chulett]

You should be editing .odbc.ini in $DSHOME and uvodbc.config in each Project directory where it will be used.

[suneelchallagali]

Hi chulett thank you for your replay, i have already entered the entry inthe uvodbc.config file even under project directory also but still i am getting error message

[btrapor]

Hi suneelchallagali,

You have to be ensure that Is the below odbc driver exists on the correct path.

/info_server/IS/Server/branded_odbc/lib/VMtera23.so