Hello,
I've finally managed to get DBD::Proxy to work with perl 5.6 (hooray!),
but now I'm getting an error which maybe someone can shed some
light on...
I'm running the following test script from a linux machine to connect to
a MS
Access database on an NT machine
use DBI;
use Data::Dumper;
my $dbh = DBI->connect(
'dbi:Proxy:hostname=192.168.0.120;port=1234;dsn=dbi:ODBC:jerrydb' ) or
die $DBI::errstr;
my $sth = $dbh->prepare( 'select * from tblRetailer' );
$sth->execute;
while( $row = $sth->fetchrow_hashref ) {
print Dumper($row);
}
$sth->finish;
$dbh->disconnect;
It works fine for a while, then it throws up the following error:
DBD::Proxy::st fetchrow_hashref failed: Server returned error: Failed to
execute method CallMethod: DBD::ODBC::st fetchrow_arrayref failed:
[Microsoft][ODBC Microsoft Access 97 Driver]Data truncated
(SQL-01004)(DBD: st_fetch/SQLFetch (long truncated) err=1) at
C:/Perl/site/lib/DBI/ProxyServer.pm line 324.
Does anyone recognise this error? Is it a problem with my setup or just
some funny data in the DB. The script is returning quite a bit of data
from the db before this. It always dies at about the same point and it
was doing the same thing previously with perl 522...
Any suggestions?
Thanks,
Kathryn.
---
You are currently subscribed to perl-win32-users as: [archive@jab.org]
To unsubscribe, forward this message to
[EMAIL PROTECTED]
For non-automated Mailing List support, send email to
[EMAIL PROTECTED]
