martin-evans.me.uk Always finish the day on a success

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.

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.

Over the last few months I've been receiving an increasing number of emails from people experiencing problems inserting date/time/datetime/timestamp values into MS SQL Server specifically although not exclusively. There are a number of MS SQL Server ODBC drivers but the ones I see the most (in no particular order) are a) MS SQL Server ODBC Driver b) MS SQL Server Native Client driver c) Easysoft's SQL Server ODBC Driver and d) freeTDS. I hope to write a more expansive tutorial on this in the near future but until then I hope this blog post will help.

Today I released a new development version of DBD::ODBC (1.23_2).

Apologies to the few people waiting on changes but I've been snowed under with work on DBIx::Log4perl, DBI and DBD::Oracle but mostly my day job (which uses all of these modules and a alot more).

Yet more time today spent tracking down another bug in Microsoft's SQL Server native client ODBC driver reported in RT for DBD::ODBC.

I released a new development release of DBD::ODBC the other day. Here is an extract from the change log:

Noel Burton-Krahn posted a patch for UTF-8 encoded data in Aster (based on Postgres) today. This prompted me to complete a number of small changes I had in the fire and incorporate his changes.

I've got a little behind in the work that has been gathering for DBD::ODBC lately so a few days ago I rt'ed a list of jobs in the hope that would stir me into action.

If you are using cygwin and unixODBC I'd like to know. I am about to make a change to DBD::ODBC which might stop it detecting unixODBC under cygwin so would appreciate talking to anyone who uses this configuration.

I uploaded DBD::ODBC 1.22_3 to CPAN yesterday.