Teradata Perl Connection Question.


G

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:Teradata:DB', 'user', 'password') or die
"Connecting : $DBI::errstr\n ";

$sth = $dbh->prepare('select * from TableX) or die "preparing: ",$dbh-
$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?
 
Ad

Advertisements

S

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:Teradata:DB', '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
 
G

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.
 
Ad

Advertisements

J

J. Gleixner

Gary said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top