in reply to Bizarre error inserting data into an Access database.

This error look like it may be due to incorrect type conversion or something like that.
The best information I was able to find suggested two slight possibilities.
1- You are trying to put too long a string into a character field and DBI is not tructating it so ODBC or the database is complaining, solution: try different data.
2- Perl and DBI are confusing type of numbers and their precision: solution tell it exactly what to use:
$sth->bind_param(1, $value, { TYPE => SQL_INTEGER });

That was the closest I could get to a solution, maybe try giving us full detail on code used, data tables in the database and what you are trying to insert. However it may still be a bug in DBI,DBD::ODBC for which you would have to contact the author.

Replies are listed 'Best First'.
Re: Re: Bizarre error inserting data into an Access database.
by ChilliHead (Monk) on Jan 02, 2001 at 13:47 UTC
    You were right, I was trying to insert a string that was too long (longer than 255).

    thanks for the help.

    CH