SAP DataServices 4, Teradata 13.10 32bit v 64bit Config

dataservices administration
1

Hi,

I am having a 32bit v 64bit issue with connecting to Teradata 13.10 from SAP Data Services 4 (14.0.1).

SDS Designer (32bit) can connect to Teradata - browse list of tables, view data etc. However when executing a job the job server (64bit) throws an error:

ODBC call <SQLDriverConnect> for data source <BWD_DEV> failed: <Specified driver could not be loaded due to system error  126: The specified module could not be found. (Teradata, D:\Program Files\Teradata\Client\13.10\ODBC Driver for Teradata nt-x8664\Lib\tdata32.dll).>. Notify Customer Support.

The path in above error message is correct except for file name of the dll. In the file system the file name is Tdata32.dll (upper case T). I wouldn’t have though that this would be an issue on windows?

I believe this path is the 64bit library as there is a similar file located at,

D:\Program Files (x86)\Teradata\Client\13.10\ODBC Driver for Teradata nt-x8664\Lib\tdata32.dll

  • this one has a dll named with a lower case t.

In the 64bit path I’ve tried renaming Tdata32.ddl to tdata32.dll but this didn’t have an effect (I hadn’t restarted the job server as we’re on a shared platform but this may be required)

Anyone got this working elsewhere?

AL

agulland :uk: (BOB member since 2004-03-17)

2

A restart of the job servers cleared up this issue.

Lesson learned?: install and test database client software prior to install of SDS or if after then restart servers or reboot server

AL

agulland :uk: (BOB member since 2004-03-17)