cannot connect to Teradata via perl on linux - getting core dumps

Connectivity
Fan

cannot connect to Teradata via perl on linux - getting core dumps

[:home/cl2515/perl] perl -MDBI -e 'DBI->installed_versions;'

  Perl            : 5.016003    (x86_64-linux)

  OS              : linux       (2.6.32-220.4.2.el6.x86_64)

  DBI             : 1.631

  DBD::Teradata   : 1.52

    DBD::ODBC       : 1.52

My code

use DBI;

use DBD::ODBC;

my $user = 'cl2515';

my $pw = 'XXXXX';

my $dsn = "dbi:ODBC:DWSAND";

my $dbh = DBI->connect($dsn, $user, $pw,

{PrintError => 1, RaiseError => 1}); 

/opt/teradata/client/15.10/bin/tdxodbc64

Enter Data Source Name: DWSAND

Enter UserID: cl2515

Enter Password:

Connecting with SQLConnect(DSN=DWSAND,UID=cl2515,PWD=*)...

.....ODBC connection successful.

ODBC version        = -03.52.0000-

DBMS name           = -Teradata-

DBMS version        = -14.10.0508  14.10.05.08-

Driver name         = -tdata.so-

Driver version      = -15.10.00.01-

Driver ODBC version = -03.51-

(type quit to terminate adhoc)

Enter SQL string :

when I run tdxodbc64 I am successfull but when I run my code above i get a core dump.Any help is appreciated . thank you

Collins

Tags (3)
1 REPLY
Fan

Re: cannot connect to Teradata via perl on linux - getting core dumps

fixed the issue!.

The ldd -d ODBC.so output indicated that Perl is loading libodbc.so.2 which is not compatible with libodbc.so that is shipped with tdodbc 15.10.00.00.

By symbolic relinking  libodbc.so.2 to point back to  libodbc.so .the issue was fixed

Thanks!