DBD::ODBC

I am happy to announce another development release of DBD::ODBC. Many thanks to everyone who has contributed to this release and especially to all my friends on the #dbi irc channel and perl monks. My intention is to add a lob writing method and full ... [More] support for DBI's DiscardString and StrictlyTyped attributes in the next development release before releasing a final development release and finally a 1.25 full release. To support the new odbc_lob_read I've had to delay the binding of columns until the first fetch instead of as before when the result-set was described. This should not have any adverse effects but you are advised to test this release as without any feedback it will move to the next final release. The changes since the last full release are: read more [Less]

I currently maintain DBD:ODBC and needed to obtain a lob (large object) in chunks. It doesn't really matter why but in general the lob is very large and I can process it in chunks in my Perl code so it makes sense to read it in chunks instead of read ... [More] it all in one go (thus requiring loads of memory). DBD::ODBC does not have this functionality currently. read more [Less]

A great deal of issues arise in the dbi-users mailing list and to me personally concerning ODBC connection issues so I thought I'd describe the ODBC connection process here (with a slight Perl angle since I look after DBD::ODBC). The information here should be of general interest to anyone using ODBC. read more

I have uploaded the official 1.24 release of DBD::ODBC to CPAN. Many thanks to everyone who has helped with this whether it was patches or testing. Here are the changes since 1.23: =head2 Changes in DBD::ODBC 1.24 May 14, 2010 Minor change in ... [More] Makefile.PL to only use NO_META if ExtUtils::MakeMaker is at least at version 6.10. Reported by Chunmei Wu. Minor change to test rt_50852 which had wrong skip count. =head2 Changes in DBD::ODBC 1.23_5 May 6, 2010 Added advice from Jan Dubois (ActiveState) on building DBD::ODBC for ActivePerl (see README.windows). read more [Less]

I the last few days I released another development release of DBD::ODBC 1.23_5. I've been waiting for smoke testers to attack this release and then I will do an official 1.24 release. Since very few smokers actually run the test code I'm going to ... [More] look at Test::Database for the next release - if you are a smoker and have Test::Database setup for DBD::ODBC I'd love to hear from you (really). 1.23_5 contains the following changes since 1.23: =head1 CHANGES =head2 Changes in DBD::ODBC 1.23_5 May 6, 2010 Added advice from Jan Dubois (ActiveState) on building DBD::ODBC for read more [Less]

I have just uploaded a new development release of DBD::ODBC 1.23_4 to CPAN. This is very much an experimental release but unless I hear any negative reports I will release this as 1.24. If you use DBD::ODBC you SHOULD test this release as it contains ... [More] some significant changes to speed up prepared statements and as DBD::ODBC has to support a large number of ODBC drivers I have not been able to test the dozens of possibilities myself. If you use the MS SQL Server ODBC Driver or Native Client this change will definitely impact you and for other drivers this should reduce calls to SQLBindParameter. read more [Less]

In the last few days whilst hanging out on the #dbi IRC channel I saw messages from someone using/developing OTRS (Open source Ticket Request System) with DBD::ODBC. read more

Recently I've had a spate of issues reported in dbi-users mailing list and direct to me wrt calling procedures in MS SQL Server. I thought it might be worth covering some of the more common ones here. read more