in reply to WIN32::ODBC - text field String data, right truncation

Check DBI documentation for "LongReadLen". Something like the following in your connect statement might help:

my $dbh = DBI->connect("dbi:ODBC:$datasource", $username, $password , {LongReadLen => 1500, RaiseError => 1}) || die "Error connecting: $!";

HTH

Update: or it might not help, since you're using Win32::ODBC, not DBI!