How to configure Teradata native driver and the Microsoft SQL Server DataDirect driver in same odbc.ini.

How to configure Teradata native driver and the Microsoft SQL Server DataDirect driver in same odbc.ini.

book

Article ID: KB0084540

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database -
Not Applicable -

Description

Description:
The following are steps to configure a Teradata native driver and a Microsoft SQL Server DataDirect driver in the same odbc.ini, which is bundled with TIBCO ActiveMatrix Adapter for Database 6.3.0 installation. If the setup of InstallDir and TraceDll are as follows, TIBCO ActiveMatrix Adapter for Database 6.3.0 Subscription service, which has dateTime columns, are failing to insert into the Target tables.

InstallDir=/usr/tibco/devsetb/adapter/adadb/6.3/odbc/:/opt/teradata/client/14.00/odbc_32
TraceDll=/usr/tibco/devsetb/adapter/adadb/6.3/odbc/lib/odbctrac.so:/opt/teradata/client/14.00/odbc_32/lib/odbctrac.so

Error reported.
---------------
DBError: 5
ErrorCode: 22007
ServerCode: 241
Message: [TIBCO][ODBC SQL Server Legacy Driver][SQL Server]Conversion failed when converting date and/or time from character string.
--------------

The cause is that two or more paths are not supported for both InstallDir or TraceDll properties in the odbc.ini file.

Issue/Introduction

How to configure Teradata native driver and the Microsoft SQL Server DataDirect driver in same odbc.ini.

Resolution

1). In the odbc.ini file, keep InstallDir as the default path such as: InstallDir=<ADB_HOME>/odbc/ .


2). Add both the Tibco ODBC driver install location and the Teradata ODBC driver install location to the LD_LIBRARY_PATH. You can edit the adbagent_env.sh file. Add <ADB_HOME>/odbc/lib and <Teradata _native_driver_path>/odbc_32/lib to LD_LIBRARY_PATH. For example, LD_LIBRARY_PATH=/Home/andrew/tibco/adapter/adadb/6.3/odbc/lib:/opt/teradata/odbc_32/lib:xxx


3). Run adbagent_env.sh. For example, run '. ./adbagent_env.sh' under <ADB_HOME>/bin.