FYI ping no longer works via DBI:ODBC:mysql

2005-12-13 Thread Martin J. Evans
Just in case anyone else stumbles into this I've just spent quite a bit of time trying to work out why my scripts are not working as intended to discover that ping no longer works via DBI:ODBC:mysql (at least in mysql-connector 3.51.12) (to sql server, oracle etc they are fine). DBD::ODBC

can't locate require_version

2005-12-13 Thread Patrick Danley
i would like to thank those that offered help with my Bareword:'DBI::SQL_INTEGER not allowed while strict subs in use error. i now receive a new error: -- Can't locate object method require_version via package DBI at /sw/ lib/perl5/5.8.6/darwin-thread-multi-2level/DBD/Pg.pm line 36.

re: Oracle 10g and DBD::Oracle

2005-12-13 Thread Jared Still
It appears that you are seeing the parse done by DBD::Oracle to describe the table. Look at the DBI docs for ora_check_sql. Turn it off and the extra parse should go away. Jared On Thu, 2005-12-08 at 11:00 -0500, Peter Santos wrote: Dear users, I'm hoping to get some insight into why oracle

can't locate require_version

2005-12-13 Thread Patrick Danley
I figured it out. Begin forwarded message: From: Patrick Danley [EMAIL PROTECTED] Date: December 13, 2005 11:38:42 AM EST To: dbi-users@perl.org Subject: can't locate require_version i would like to thank those that offered help with my Bareword:'DBI::SQL_INTEGER not allowed while strict

LongReadLen, lengthb() and Oracle

2005-12-13 Thread Ron Savage
Hi Folks The DBI docs for LongReadLen say to use LENGTHB() for Oracle, but that gives me an error: ORA-00932: inconsistent datatypes: expected NUMBER got LONG when I do: select max(lengthb(a_session) ) from sessions; And, yes, sessions is for CGI::Session, and a_session is of type long. This