I'm unfortunately having to migrate a CGI from MySQL to MS-Access, and
biting my teeth out in the process. In particular, I'm not able to fethch
the contents of "longbinary" fields.
This is what my sample code looks like:
use DBix::Recordset;
$self = DBIx::Recordset->SetupObject({
'!DataSource' => 'DBI:ODBC:driver=Microsoft Access Driver
(*.mdb);dbq=c:\\temp\\zvsn.mdb',
'!Username' => undef,
'!Password' => undef,
'!Table' => 'zvsnfahrplaene'
}) ;
$self->Search({
'id' => '998044594',
'$fields' => 'id, image'
}) ;
while ($results = $self->Next) {
print $results->{id},"\t",$results->{image} , "\n" ;
}
And this is the error message that I'm receiving:
DBD::ODBC::st fetchrow_arrayref failed: [Microsoft][ODBC Microsoft Access
Driver]Die Zeichenfolgedaten wurden rechts abgeschnitten. bei Spalte 2
(image) (SQL-01 004)(DBD: st_fetch/SQLFetch (long truncated) err=1) at
C:/Programme/Perl/site/lib/DBix/Recordset.pm line 1538.
After poking around in various newsgroups, I found a number of references to
the DBI attribute '$dbh->{LongReadLen}', and so I included the line
"$self->DBHdl->{LongReadLen} = 180000" in my script, but it has made no
difference.
Heyelp!
----------------------------------------------------------------------------
Carl K. Cunningham
Roberts� interactive GmbH
E-Mail: initials of first and last name, at 'roberts' dot 'de'
----------------------------------------------------------------------------
