Perl crashing, citing libmsql__.dll as culprit(?)

2015-12-07 Thread Meir Guttman
Dear DBI users, I use Perl, DBI and DBD:mysql for years, without a problem. But working on my latest project I encounter Perl often, but *not always(!) *crashing with the Windows message "Perl interpreter has stopped working". As far as I can tell the script runs to its natural end.I must add that

Perl crash citing libmysql__.dll as culprit(?)

2015-12-07 Thread Meir Guttman
Dear DBI users, I use Perl, DBI and DBD:mysql for years, without a problem. But working on my latest project I encounter Perl crashing with the Windows message "Perl interpreter has stopped working". As far as I can tell the script runs to its natural end. I must add that together with this ("Poste

RE: Bad error message

2014-07-29 Thread Meir Guttman
> -Original Message- > From: Peter J. Holzer [mailto:h...@wsr.ac.at] > Sent: יום ג 29 יולי 2014 11:23 > To: Stuart Cooper > Cc: Meir Guttman; dbi-users@perl.org > Subject: Re: Bad error message > -- > > However, not all RDBMSs support proper prepared s

Bad error message

2014-07-27 Thread Meir Guttman
Dear DBI folks, The other day I had a trivial typo in my DBI SQL query that gave me an outlandish error message and grief. So outlandish that I spent two hours looking for the culprit. All it was is a missing closing back-tic in the db name part of the `database_name`.`table_name` SQL clause, see

RE: :ODBC 1.46_1 released - You REALLY need to test this release

2013-11-17 Thread Meir Guttman
Dear Martin > -Original Message- > From: Martin J. Evans [mailto:boh...@ntlworld.com] > Sent: שבת 16 נובמבר 2013 12:34 > To: dbi-users@perl.org; DBI Developers Mailing List; dbi-annou...@perl.org > Subject: DBD::ODBC 1.46_1 released - You REALLY need to test this release > > I've just upl

RE: utf8 and mysql

2013-07-31 Thread Meir Guttman
Dear Gabor, You must include «mysql_enable_utf8 => 1» hash record in the connection attributes used when you create the DBI handle my %conn_attrs = (RaiseError=> $RaiseError, PrintError=> $PrintError, AutoCommit=> $AutoCommit, mysql

Retrieving the CURRENT default database name

2012-10-22 Thread Meir Guttman
Dear mavens, My application interacts with a MySQL DBMS. There I am using subroutines and packages that set the various attributes passed to the DBI "connect" method. Also, I later switch databases based on a user's input by executing a "USE 'DB_name'" SQL statement. What I am after is a way to deb