Ensure that you set the Driver parameter to the file name and location of the native ODBC driver for the database, with the library suffix that is appropriate for the operating system, for example, .so
for Solaris and AIX, or .sl
for HP-UX.
The following example provides details for a Teradata data source on Linux, with a data source name of Tera_Northwind.
[Tera_Northwind]
Driver=/opt/teradata/client/14.10/odbc_64/lib/tdata.so
Description=NCR 3600 running Teradata V2R6.2
DBCName=10.345.67.899
astUser=
Username=northwind
Password=northwind
Database=northwind
DefaultDatabase=northwind
NoScan=no
If you have selected the option Require fully qualified table names in the General tab of the Connection Pool dialog for this data source in the Administration Tool, the DefaultDatabase
parameter does not require a value.