http://qs321.pair.com?node_id=175689


in reply to Win32::ODBC - connecting to Remedy AR System

You might find it useful to check for errors and write debugging information like:
if ($odbc->Error) { $odbc->DumpError; exit; }
Checking after you call FetchRow might help. Also you might need to increase your buffer size (in bytes): $odbc->SetMaxBufSize(50_000); I've found that ODBC has problems with memo fields in Access and this has helped. It seems to skip rows that are bigger than the maximum buffer size without flagging an error. I've had success cranking this number up to a meg or so (though record retrieval is slow).

Hope this helps...

gav^