Ingres comes to DBD::ODBC

Yesterday I was contacted by someone at Ingres with a patch to make DBD::ODBC support the ingresCLI driver manager. I'm always happy to accept these patches and with a moderate rewrite (necessitated by the fact I'd hacked Makefile.PL around a lot recently for 64bit support without checking it in) I managed to rewrite the patch. The changes are checked in to subversion now and are reported to work for Ingres. Unicode support is not there yet but I believe they are working on it.

Detecting 64bit ODBC driver managers in DBD::ODBC install

I've been working on 1.22 doesn't compile on 64 bit systems with unixODBC on and off for a few days. Boy, this is tiresome (no reflection on the poster of this rt).

DBD::ODBC ping has regressed :-(

Today a long standing Easysoft customer upgraded from DBD::ODBC 1.13 to 1.21 and their scripts stopped working properly :-( It appears they use the ping method to detect whether the connection handle is connected to the database and since upgrading to 1.21 they are getting DBD::ODBC::db ping failed: Cannot allocate statement when disconnected from the database at ./xxx.pl line 11 when calling the ping method after a disconnect.

Quick summary of content network clicks/cost/conversions

I use the content network sparingly and in campaigns which are for the content network only. However, I've never felt google chooses the sites to display my ads very well so review the sites regularly. The things I'm mostly interested in are a) which sites my ads appeared on I don't think they should (or I don't want them appearing on) and b) which sites are costing a lot but delivering no conversions. The following perl script processes a TSV version of the placement report (with specific fields) into a more easily managed list I can use to add domain exceptions to my campaign.

New attribute to DBIx::Log4perl to filter error reporting

At Easysoft we have been using DBIx::Log4perl for some time to log DBI database access methods in a way that was useful to us. In fact, that is why I wrote DBIx::Log4perl in the first place.

Inserting code into drupal content

I spend all day writing code so it is not unnatural that I blog about it too. I know drupal has code tags but they still end up changing < and > and most code is full of those. There seems to be loads of solutions but many of them have problems - use of code, pre and xmp tags (not all browsers do the same thing with xmp), substituting &#60; etc for < (too annoying, I wan to just paste my code in). Ginally I found the GeSHI filter and although it is not perfect it works better (by far) than any of the other solutions I've found.

Why cannot I use a RowCacheSize greater than 128 with DBD::Oracle?

It appears that DBD::Oracle restricts the RowCacheSize to 128, why? I know how much memory I can afford to use for retrieving rows better than DBD::Oracle and as far as I can see this could be set a lot higher.

Outages on my virginmedia broadband connection

Another frustrating day with my broadband connection - thank you Virgin Media - not!

DBD::ODBC 1.22 released

I have released 1.22 of DBD::ODBC to CPAN today. This includes a fix to a serious problem with a unicode-enabled DBD::ODBC (the default on Windows) and the transfer of character fields between the database and Perl of greater than 64K characters. If this affects you then you should upgrade immediately. See the announcement on the dbi-users/dbi-dev or dbi-announce lists. This release also fixes a problem with inserting NULL into nvarchar fields in a unicode-enabled DBD::ODBC.

drupal on fasthosts won't send email

Ok, I'm new to drupal but I set up an email action to email me and associated it with a new comment. Then I added a comment as someone else and no email arrived. Then I found Using Drupal's email address in the mail.inc main function with -f which seemed to suggest the from address must be set if you are on fasthosts. Anyway the patch provided to mail.inc worked just fine. I include it here, partly as a reminder to me that I made this change:

Syndicate content