Teradata Perl Connection Question.

[Gary]

Hi

I'm trying to post to the teradataforum but couldn't find any link to
post.

I'm trying to connect to Teradata and getting the following error.

CODE:



my $dbh;

my $sth;

my @row;

$dbh = DBI->connect('dbi:TeradataB', 'user', 'password') or die
"Connecting : $DBI::errstr\n ";

$sth = $dbh->prepare('select * from TableX) or die "preparing: ",$dbh-

errstr;

$sth->execute() or die "executing: ", $dbh->errstr;

while (@row = $sth->fetchrow_array()) {
print "displaying";
print join(',',@row);
print "\n";
}



--Note DB, user, password have been supplied.



ERROR:

Cannot init, result is 510

Use of uninitialized value in concatenation (.) or string
at /...../......../DBD/Teradata.pm line 5078



Also does DBD:Teradata module supports encrypted logons?

 

[smallpond]

Hi

I'm trying to post to the teradataforum but couldn't find any link to
post.

I'm trying to connect to Teradata and getting the following error.

CODE:

my $dbh;

my $sth;

my @row;

$dbh = DBI->connect('dbi:TeradataB', 'user', 'password') or die
"Connecting : $DBI::errstr\n ";

$sth = $dbh->prepare('select * from TableX) or die "preparing: ",$dbh->errstr;

$sth->execute() or die "executing: ", $dbh->errstr;

while (@row = $sth->fetchrow_array()) {
print "displaying";
print join(',',@row);
print "\n";

}

--Note DB, user, password have been supplied.

ERROR:

Cannot init, result is 510

Use of uninitialized value in concatenation (.) or string
at /...../......../DBD/Teradata.pm line 5078

Also does DBD:Teradata module supports encrypted logons?

What happened when you ran the test as suggested by the documentation?

"After installing, you can verify the install by running
perl t/test.pl <host> <user> <password>"

--S

 

[Gary]

smallpond,

Thank you for your reply.

This is what I get when I run test.pl

TdTestBulkload.pm line 4:

This Perl hasn't been configured and built properly for the threads
module to work. (The 'useithreads' configuration option hasn't been
used.)

Having threads support requires all of Perl and all of the XS modules
in
the Perl installation to be rebuilt, it is not just a question of
adding
the threads module. (In other words, threaded and non-threaded Perls
are binary incompatible.)

If you want to the use the threads module, please contact the people
who built your Perl.

Cannot continue, aborting.
BEGIN failed--compilation aborted at /usr/opt/BASperl/5.8.6/lib/sun4-
solaris/threads.pm line 28.
Compilation failed in require at TdTestBulkload.pm line 4.
BEGIN failed--compilation aborted at TdTestBulkload.pm line 4.
Compilation failed in require at test.pl line 17.
BEGIN failed--compilation aborted at test.pl line 21.

 

[J. Gleixner]

smallpond,

Thank you for your reply.

This is what I get when I run test.pl

TdTestBulkload.pm line 4:

This Perl hasn't been configured and built properly for the threads
module to work. (The 'useithreads' configuration option hasn't been
used.)

Having threads support requires all of Perl and all of the XS modules
in
the Perl installation to be rebuilt, it is not just a question of
adding
the threads module. (In other words, threaded and non-threaded Perls
are binary incompatible.)

If you want to the use the threads module, please contact the people
who built your Perl.

That seems like a pretty helpful error message.