6
I Use This!
Inactive

News

Analyzed about 12 hours ago. based on code collected 1 day ago.
Posted almost 13 years ago by martinjevans
This all started with a stackoverflow question at Automatic character encoding handling in Perl / DBI / DBD::ODBC. It then led to DBD::ODBC doesn't handle windows-1252 characters and lastly a small discussion on dbi-dev at Decoding data from the database in DBD. read more
Posted about 13 years ago by martinjevans
Changes in DBD::ODBC 1.29 March 8, 2011 An official release of the 1.28 development releases. [NOTE] The 1.28 development releases made a change which causes a generic error to be reported when an ODBC call fails but an error message is not ... [More] retrieved from the ODBC Driver. It appears this has caught out a few ODBC drivers - notably freeTDS and Firebird. You now may see errors that were missed before e.g., DBIx::Class's tests for Firebird now errors test 21 "outer txn rolled back" (and others) because SQLRowCount returns an error after "ROLLBACK TO SAVEPOINT savepoint_0"; before this error was missed. read more [Less]
Posted about 13 years ago by martinjevans
I'm about to release DBD::ODBC 1.29 after 4 development releases. Unfortunately, (as is often the case) I've found a bug just after the last development release related to batching of SQL statements and odbc_more_results. I'm fairly confident in it ... [More] but if you use DBD::ODBC I'd love you to test it before I release it as it may be a while before I can release a new version. You can find it here [Less]
Posted about 13 years ago by martinjevans
I came across someone asking about DBIx::ProcedureCall today on Perl Monks in Execute Oracle Stored procedure using DBIx::ProcedureCall. Years ago I remember finding DBIx::ProcedureCall when we were about to embark on writing an application that used ... [More] stored procedures in DB2, Oracle and MySQL. DBIx::ProcedureCall did not support DB2 and MySQL then and I was not that happy about the way it creates symbols in Perl for database procedures/functions so I dismissed it and I wrote my own code. When I saw it again on Perl Monks I thought I'd take another look at it and was surprised the supported DBDs has not increased (it is still Oracle and Postgres). read more [Less]
Posted about 13 years ago by martinjevans
I've just released DBD::ODBC 1.27. Version 1.27 combines all the 1.26 development releases and is a significant release as DBD::ODBC is now entirely ODBC 3.0 and requires an ODBC Driver Manager for any ODBC 2.0 drivers. Many thanks to everyone who ... [More] has contributed. The changes are listed below. =head2 Changes in DBD::ODBC 1.27 December 29, 2010 Official release of the 1.26 development releases. =head2 Changes in DBD::ODBC 1.26_4 December 14, 2010 read more [Less]
Posted over 13 years ago by martinjevans
I've recently uploaded a new experimental (and development) release of DBD::ODBC 1.26_1 to CPAN. This contains over 200 block code changes so it is a VERY significant change and should not be used on production servers until you have tested it. This ... [More] release adds little in the way of functionality (and a few bug fixes) but is a major push to get DBD::ODBC truely ODBC 3.0 compliant and as such it will REQUIRE an ODBC driver manager to translate ODBC 3.0 calls to ODBC 2.0 if you are unlucky enough to have an ODBC 2.0 driver. I include the changes below but a few notes in addition: read more [Less]
Posted over 13 years ago by martinjevans
Firstly, I should say I don't use Windows that much these days. The Windows machines where I test DBI and DBD::ODBC I set up ages ago with a Perl built with MS Developer Studio and I tend to keep them for that purpose. However, I bought a whole load ... [More] of nice shiny new parts to build myself a new PC a month ago and installed Ubuntu and Windows as I thought I could get a more up to date Perl on Windows at home. read more [Less]
Posted over 13 years ago by martinjevans
I'm pleased to announce the 1.25 release of DBD::ODBC. A full list of changes since the last major release is listed below and at DBD::ODBC Changes. New features include support for MS SQL Server's XML type, a new odbc_lob_read method, overriding of ... [More] types on bind_col. Many thanks to everyone who has reported issues and helped with the development and testing of DBD::ODBC and especially all my friends on #dbi, Perl Monks and my colleagues at Easysoft Limited.. read more [Less]
Posted over 13 years ago by martinjevans
Today someone posted a problem using the SQL Server XML datatype with DBI/DBD::ODBC on the dbi-users mailing list. I sorted their problem pretty quickly but noticed his code using length() on scalars which were bound with bound_col was not reporting the correct length. The example and output are below: read more
Posted over 13 years ago by martinjevans
In the last few days I've released what hopefully will be the last development release of DBD::ODBC (1.24_4). If you run Windows especially and Perl 5.13 even more, then please test. read more