Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:


Brethren;

I'm trying to connect to a Teradata database using Perl DBI from a UNIX aix box. I can connect from my Windows
box via ODBC with no problem. Therefore, I know my userid can connect and run SQL with no errors.
I have perl-5.12.2, DBI 6.51, DBD-Teradata 12.001, DBD-Teradata-Cli-12.001 and cliv2_AIX_POWER.13.10.008
installed on a UNIX box running AIX 6.1 trying to connect to a Teradata database version 13.10.03.03
code is as follows

use DBI; use DBD::Teradata; use DBD::Teradata::Crypt; use DBD::Teradata::Diagnostic; use DBD::Teradata::GetInfo; use DBD::Teradata::PMAPI; use DBD::Teradata::TypeInfo; use DBD::Teradata::Utility; use Time::HiRes qw(time); my $dbh = DBI->connect("DBI:Teradata:$tdbc:1025", $db_user, $db_passwd, {PrintError => 0 }); if ($DBI::err){ print "\nEIS-430 Error connecting to $db_name \n DBI Err: $DBI::err +str \n"; exit -1; } else { print "\nConnected to database $db_name ..\n"; } exit 0;

I get the following error

DBI Err: Deprecated logons are not allowed. Upgrade client software to latest version.

I don't know if my cliv is not the correct one
or my userid and password are not being encrypted
or there is another problem. Any suggestons?

Replies are listed 'Best First'.
Re: Unable to connect to Teradata via Perl DBI and DBD-Teradata
by Anonymous Monk on Mar 30, 2012 at 23:25 UTC