Re: Dbix::Recordset & longbinary fields in Access

[Gerald Richter]

Try to put !DBIAttr in your setup call (and of course make sure your image
data isn't bigger then 180.000) :

use DBix::Recordset;
$self = DBIx::Recordset->SetupObject({
    '!DataSource' =>    'DBI:ODBC:driver=Microsoft Access Driver
(*.mdb);dbq=c:\\temp\\zvsn.mdb',
    '!DBIAttr' => { LongReadLen => 180000 },
    '!Username' =>        undef,
    '!Password' =>        undef,
    '!Table' =>        'zvsnfahrplaene'
    }) ;

This works for me, but I havn't tried such large objects which MSAccess...

Gerald