You are are missing the DBD driver for ODBC.
What's missing from your message is what Perl you are using.
I'll presume that it is ActiveState Perl.
I'll also presume that you used the PPM tool to install DBI from an ActiveState
repository.
If true, the solution is to use PPM to install DBD::ODBC.
Capacio, Paula J wrote:
my $stmt = 'select count(*) from sysibm.badTblnm ';
my $sth = $dbh->prepare($stmt) or die "Prepare Failed\n";
DBD::DB2 doesn't seem to return false values for failures. Instead, try
checking the sqlstate of the db handle:
my $sth = $dbh->prepare($stmt);
if ($dbh->
I have two computers one a Windows XP computer and the other a Windows
2003 server. I am trying to write a script that will connect to the MS
SQL DB on the Windows 2003 server but I am having problems running it on
the Windows XP computer. It works find on the Windows 2003 computer. The
error I
Paula J Capacio wrote:
Hello,
I have successfully executed SQL statements to a DB2 database from perl
5.8.2 using DBI V1.48 and DBD::DB2 V0.78 on AIX 5.2.2.0. I'm now testing
the error handling, and it is not working as I expect. For instance I
try to prepare a statement I know will fail but er
Hello,
I'm now using Perl 5.005, DBI-1.15, DBD-DB2-0.75 on AIX 4.3.
And like to upgrade them to Perl 5.8, DBI-1.48, DBD-DB2-0.78.
Installation may be ok, but when I INSERT double bytes characters,
I get the following error.
[IBM][CLI Driver] CLI0109E String data right truncation.
I'm using Japan
