Example of ODBC Settings for Teradata

The following example illustrates how you might edit odbc.ini to connect to a data source database, “terasource”, using a vendor-supplied ODBC driver.

Solaris and AIX

[ODBC Data Sources]
terasource=Teradata source

...

[terasource]
Driver=/usr/odbc/drivers/tdata.so #teradata installation path of .so file
DBCName=abcd0072.us.xyzco.com
PortNumber=1025

HP-UX

[ODBC Data Sources]
terasource=Teradata data source

...

[terasource]
Driver=/usr/odbc/drivers/tdata.sl #teradata installation path of .sl file
DBCName=abcd0072.us.xyzco.com
PortNumber=1025