Re: Getting off the DBI-Users mailing list [was: Re: SQLite 3.3.16 nulls test results]

2007-05-04 Thread Alexander Foken
Improvement proposal for this list: Add a footer to each message send out by ezmlm, stating at least how to unsubscribe. I know that this information is already in the mail headers, but most people do not read the mail headers, except for those headers displayed by their mail user agent

DBD::ODBC tries to bind nonexisting placeholders

2007-05-04 Thread Andon Tschauschev
Hello everybody, I'm using DBI v1.51 and DBD::ODBC v1.13. I'm connecting to MSSQL2000/MSSQL2005. Statements are executed in prepare-execute-fetch order. Everything works fine, since I found something suspicious: if a string :00 occurs in a comment, then DBD::ODBC tries to bind this

Re: DBD::ODBC tries to bind nonexisting placeholders

2007-05-04 Thread Martin Evans
Andon Tschauschev wrote: Hello everybody, I'm using DBI v1.51 and DBD::ODBC v1.13. I'm connecting to MSSQL2000/MSSQL2005. Statements are executed in prepare-execute-fetch order. Everything works fine, since I found something suspicious: if a string :00 occurs in a comment, then DBD::ODBC

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testing with RH lunix Red Hat Linux 3.2.3-54 and perl 5.8 Ran Perl Makefile.PL but with this warning *** You are using a perl configured with threading enabled. *** You should be aware that using multiple threads is *** not recommended for production environments. *** Note: The optional

Re: Proposal for new $h-{ReadOnly} attribute

2007-05-04 Thread Scott Smith
Doing set transaction read only on Oracle has additional side-effects besides making the connection unable to write: it switches the read consistency level from per-statement (the default) to per-transaction. This effectively freezing the connection in time, allowing multiple queries to be

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Well just had another crack at it with a little more success I checked my ENV variable and I had LANG=en_US.UTF-8 set I removed this from my ENV and the Makefile.PL make and make test all worked as expected John Scoles [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Testing

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows XP Home Edition 2002 SP 2 Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows Server 2003 SP 2 Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Testes with Windows Vista Home Edition Windows Visual C++ Toolkit 2003 Makefile.pl, nmake, nmake test, nmake install; all worked without issue. Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Scoles
Opps forgot to note that all my Windows testing was done with the latest version of ActivePerl Tim Bunce [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] You can download it from http://homepage.mac.com/tim.bunce/.Public/perl/DBI-1.55-RC3.tar.gz =head2 Changes in DBI 1.55 (svn

RE: :ODBC tries to bind nonexisting placeholders

2007-05-04 Thread CAMPBELL, BRIAN D \(BRIAN\)
Yes, I was able to reproduce your result with this configuration: Perl 5.8.7, DBI v1.53 and DBD::ODBC v1.13, connectiong to MSSQL2000. Seems that any number of zeros (:0, :00, :000) will cause the problem, as long as it is NOT followed by any other numeric digits. -Original Message-

Re: Proposal for new $h-{ReadOnly} attribute

2007-05-04 Thread Tim Bunce
On Fri, May 04, 2007 at 08:15:53AM -0500, Scott Smith wrote: Doing set transaction read only on Oracle has additional side-effects besides making the connection unable to write: it switches the read consistency level from per-statement (the default) to per-transaction. This effectively

proliferation of error messages

2007-05-04 Thread Mary Anderson
Hello all, My perl cgi script which runs dbi is generating error messages to the logs just about everytime dbi is called. The program appears to be running correctly. How do I keep from getting the spurious messages sent? Mary Anderson

Re: proliferation of error messages

2007-05-04 Thread John Scoles
What are the messages??? - Original Message - From: Mary Anderson [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Friday, May 04, 2007 1:04 PM Subject: proliferation of error messages Hello all, My perl cgi script which runs dbi is generating error messages to the logs just

Re: Proposal for new $h-{ReadOnly} attribute

2007-05-04 Thread Scott Smith
Tim Bunce wrote: On Fri, May 04, 2007 at 08:15:53AM -0500, Scott Smith wrote: Doing set transaction read only on Oracle has additional side-effects besides making the connection unable to write: it switches the read consistency level from per-statement (the default) to per-transaction.

Re: proliferation of error messages

2007-05-04 Thread Martin Gainty
If you're running Berkeley then start your kernel with desired log option e.g. amd -l syslog (Log all messages to syslog) amd -l /dev/stderr (log to stderr) Dont know for sure if this answers your question Viel Gluck/Buena Suerte Martin-- This email message and any files transmitted with it

Re: ANNOUNCE: DBI 1.55 RC3

2007-05-04 Thread John Costello
Hi Tim, OS: OpenBSD 4.0 Perl: 5.8.8 CC: GCC 3.3.5 (single-threaded) Tests: All successful, 31 tests and 373 subtests skipped OS: Windows XP Pro/ cygwin-thread-multi-64-int Perl: 5.8.7 CC: GCC 3.4.4 Tests: All tests successful, 27 tests and 377 subtests skipped

FWD: Re: proliferation of error messages, sample of error messages

2007-05-04 Thread Mary Anderson
John, Here is a representative sample of the error output. Most of it has to do with DBI. But then it will generate a whole bunch of purely perl error messages about undefined variables, etc. However, while it is doing all of this, the application appears to be doing exactly what it is

ANNOUNCE: DBI 1.55

2007-05-04 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.55.tar.gz size: 477884 bytes md5: 0a6eda0cb7dbd8e7bc49b03dbac7c3b2 =head2 Changes in DBI 1.55 (svn rev 9504), 4th May 2007 Fixed set_err() so HandleSetErr hook is executed reliably, if set. Fixed accuracy of profiling when perl configured to use

Re: FWD: Re: proliferation of error messages, sample of error messages

2007-05-04 Thread Alexander Foken
Looks like DBI trace is enabled. Look at the DBI manpage for how to enable and disable this feature. Can be done via Environment variables or DBI method call. Alexander Mary Anderson wrote: John, Here is a representative sample of the error output. Most of it has to do with DBI. But