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.

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.

Issue/Introduction

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

Feedback

thumb_up Yes

thumb_down No

Welcome to "KB Articles"