Support for ParamValues in dbd::mysql and a note on DBD::ODBC

2006-03-31 Thread Martin J. Evans
It would appear dbd::mysql 3.0002_4 does not support ParamValues. As far as I can see it is also not in _5. I am far from an XS expert but the following addition to dbd_st_FETCH_attrib in dbdimp.c seems to work. If anyone cares to comment on whether there is a better or proper way to do this I'd

DB2.pm for Perl 5.8 needed

2006-03-31 Thread Bergners, Andrei
Hi, I am looking to install the Win32 DB2.pm library for perl 5.8.7 or 5.8.8. The previously recommended site of http://ftp.esoftmatic.com/DBI/ http://ftp.esoftmatic.com/DBI/ no longer seems to contain the necessary ppds. Can someone recommend another location? thanks andrei

Re: DB2.pm for Perl 5.8 needed

2006-03-31 Thread John Scoles
Since you are in windows you might want to just to use Activeperl and ppm to get the latest version which I think is ' DBD-DB2 [0.76] DBD-DB2' - Original Message - From: Bergners, Andrei [EMAIL PROTECTED] To: dbi-users@perl.org Sent: Friday, March 31, 2006 10:01 AM Subject: DB2.pm

Re: DB2.pm for Perl 5.8 needed

2006-03-31 Thread Dan Scott
This is a nice thought, but the latest release of DBD::DB2 is actually 0.78 (released a long time ago), but ActiveState wasn't interested in updating their version of the package because DBD::DB2 prereqs the DB2 Runtime Client. Apparently ActiveState has made it a policy to avoid offering

Re: DBI windows binaries

2006-03-31 Thread Ron Savage
On Thu, 30 Mar 2006 17:32:42 -0500, Boris Kunyavsky wrote: Hi Boris http://theoryx5.uwinnipeg.ca/ppms/ -- Cheers Ron Savage, [EMAIL PROTECTED] on 1/04/2006 http://savage.net.au/index.html Let the record show: Microsoft is not an Australian company

$sth-execute(@$bindVars) is outputting an error

2006-03-31 Thread Peter Loo
Hi, I am trying to pass an array reference to $sth-execute and I am getting the following error: DBD::ODBC::st execute failed: called with 38 bind variables when 0 are needed at /usr/local/apps/common/devl/bin/GlobalRoutines.pm line 42. The code I am using is as follows: sub

Re: ODBC w/ MS SQL

2006-03-31 Thread Thomas A. Lowery
You need an ODBC manager with the freetds driver. I suggest unixODBC. One issue you may run into is that when a query fails to prepare, you may only receive a prepare failed... message without additional information as to why it failed. Also, I've had problems with place holders not