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

2009-08-03 Thread Denis BUCHER
Hello Martin, Martin J. Evans a écrit : > 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 : >

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

2009-08-03 Thread Martin J. Evans
Denis BUCHER wrote: 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

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

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

2009-08-03 Thread Martin Evans
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 at perl/DBI level... >> >>

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

2009-08-03 Thread Denis BUCHER
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 at perl/DBI level... > > What I do : >> use DBI; >> $dbh

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: 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