Re: Retrieving warnings after executing a MySQL INSERT statement

2009-08-03 Thread Peter J. Holzer
On 2009-07-28 09:19:05 -0700, David Goodman wrote: I suggest that you check to see if the string $DBI::errstr is empty rather than just whether the 'do' function executed correctly. It seems that the SQL is correctly submitted from the DBI side but the database server actually produces an

Problem with perl DBI ODBC driver (bug or misconfig ?) [String data right truncation]

2009-08-03 Thread Denis BUCHER
Hello, I'm trying to simply do a SELECT from an ODBC source. It works perfectly in PHP but not in perl ! Therefore there is no problem at source or at ODBC level, it seems to reside at perl/DBI level... What I do : use DBI; $dbh = DBI-connect('dbi:ODBC:' . $dsnname, $dbuser, $dbpwd) or...

Re: Problem with perl DBI ODBC driver (bug or misconfig ?) [String data right truncation]

2009-08-03 Thread Denis BUCHER
Hello Martin, Martin Evans a écrit : Denis BUCHER wrote: Hello everyone, Some precisions to my previous email... I'm trying to simply do a SELECT from an ODBC source. It works perfectly in PHP but not in perl ! Therefore there is no problem at source or at ODBC level, it seems to reside