I have a Perl program that writes binary data to a SQL Server image field using DBD::ODBC.
This works fine in Perl 5.8.8 build 822 ($DBD::ODBC::VERSION = '1.13';) However, there are two problems with build 824 with an upgraded ODBC or with Perl 5.10.0 build 1004. First - data written to the image field is being truncated, i.e. not all of the data shows up in the database. Writing the data to a file at the same time as writing to the database shows that program is still generating the data correctly, so the fault is with DBI or DBD::ODBC. Second - on reading the data, ODBC thinks the size is longer than it actually is and gives me right truncation errors unless I increase the long read length by a factor of 10. Does anyone have any clue as to what might be happening here for me. Any help would really be appreciated. Thanks Horace _______________________________________________ ActivePerl mailing list [email protected] To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
