Version 1.0 of DBD::ODBC is finally out!
This is a significant update of the DBD::ODBC module over the latest
non-developer release DBD::ODBC 0.43. I believe it meets nearly all of
the DBI specifications, the most notably missing, though, is the array
insert speed enhancements (upcoming).
A quick summary of changes/fixes include (details in Changes.pm or
perldoc DBD::ODBC::Changes):
- ODBC 3.0 API usage
- odbc_err_handler and odbc_async_exec which allows retrieving
of messages from long-running operations which produce messages.
- Added support for DBI specification for ParamValues
- Many patches for multiple result set handling (thanks to many,
many people)
- Fixed global destruction access violation
- Add odbc_force_rebind for handling statements/stored procs
which can return different result sets (i.e. different number of
columns, etc).
- Add support for threading with CLONE method (but threads still
not tested by me -- yet)
- Added odbc_execdirect to force using SQLExecDirect for those
drivers which need it
- Lots of little build things...the details are in Changes.pm
Many thanks to those who provided patches, examples and support. Many
Many thanks to Martin Evans for fixes, support, guidance and help
testing.
Enjoy!
Jeff
Most recent fix over the last developer release include:
Updated Makefile.PL to handle SQL_Wxxx types correctly with unixODBC
and linking
directly with EasySoft OOB. Note that I could not find where iODBC
defines SQL_WLONG_VARCHAR,
so I'm not sure it's fixed on all other platforms. Should not have
been a problem under
Win32...
Found that the fix in _18 was only enabled if debug enabled and it
broke something else.
removed the fix.
Updated Makefile.PL to use DBI version 1.21 instead of 1.201 to
facilitate builds under
latest development versions of Perl.
Updated code to use the *greater* of the column display size and the
column length for
allocating column buffers. This *should* workaround a problem with
DBD::ODBC and the
Universe database.
Added code thanks to Michael Riber to handle SQLExecDirect instead of
SQLPrepare. There are
two ways to get this:
$dbh->prepare($sql, { odbc_execdirect => 1});
and
$dbh->{odbc_execdirect} = 1;
When $dbh->prepare() is called with the attribute "ExecDirect" set to a
non-zero value
dbd_st_prepare do NOT call SQLPrepare, but set the sth flag
odbc_exec_direct to 1.
Fixed numeric value binding when binding non-integral values. Now lets
the driver
or the database handle the conversion.
Fixed makefile.pl generation of makefile to force the ODBC directory
first in the
include list to help those installing ODBC driver managers on systems
which
already have ODBC drivers in their standard include path.
> -----Original Message-----
> From: PAUSE [mailto:[EMAIL PROTECTED]]
> Sent: Sunday, December 08, 2002 11:16 PM
> To: Jeff Urlwin; [EMAIL PROTECTED]
> Subject: CPAN Upload: J/JU/JURL/DBD-ODBC-1.00.tar.gz
>
>
> The uploaded file
>
> DBD-ODBC-1.00.tar.gz
>
> has entered CPAN as
>
> file: $CPAN/authors/id/J/JU/JURL/DBD-ODBC-1.00.tar.gz
> size: 86912 bytes
> md5: c1d5d02665b1dbee2c85c2a913449ce4
>
> No action is required on your part
> Request entered by: JURL (Jeff Urlwin)
> Request entered on: Mon, 09 Dec 2002 04:14:03 GMT
> Request completed: Mon, 09 Dec 2002 04:15:46 GMT
>
> Virtually Yours,
> Id: paused,v 1.81 2002/08/02 11:34:24 k Exp k
>
