TeraData Odbc Connection

myukassign · Post by **myukassign** » Tue Sep 14, 2010 5:06 am

I was trying to create an odbc dsn to TeraData. In the odbc.ini file, I see the driver its referring is

/opt/IBM/InformationServer/Server/branded_odbc/lib/ivtera23.so.

But I am not able to see this driver there.

Is it possible that this driver is not shipping with the IIS installation or I need to do something to bring this driver in this path.

I am sure I selected all the options during the installation of IIS.

Please help

chulett · Post by **chulett** » Tue Sep 14, 2010 5:51 am

If it is not in that "branded_odbc" folder with the other drivers, then it seems to me you need to contact your official support provider and see what they need to do to get that to you... a patch, perhaps?

myukassign · Post by **myukassign** » Mon Sep 27, 2010 4:54 am

thanks Chullet.

I got a new fix from IBM fix central. The fix contain a branded_odbc folder itself with all the drivers in it. The teradata driver also was present there.

My issue solved.

If some one searching for teradata connectivity. Please do the following steps.

Step1. Make sure your driver is present in branded_odbc folder.

Step2. Check the odbc.read me file in the same folder and check which all teradata database it supports.

Step 3. if you see for e.g. 12.0 then download the free download teradata CLI ( that is client) from teradata website.

Step 4. install the client and set the lib path and bin path in the dsenv file.

Step 5 Recycle the server.

Step 6 it should work now.