Category: General

My friends (Lekan ‘Sully’ Sule and his wife, Madam Sule) just dropped a bouncing baby boy. He’s named Olamide Olalekan-Sule. Many congrats to the family.

Meanwhile, Madam Sule has been clamoring for Olamide to marry my baby girl. I am sad to say, however, that that would be very difficult to do. You know what? We ‘ve got some, em, eligible bachelors groomed to woo Dara. So he’s got to join the queue and prove his mettle.

Otunba Lekan Sule is a Network Administrator with Access Bank Plc in Nigeria

I don’t know how I could describe the frustration I have passed through when a linked DB2 server on MS SQL started returning 1 single row using the openquery syntax.

After trolling on the net for days, I finally found a solution at http://sastools.com/b2/post/79394261#comments

At last, macromedia.com was finally collapsed into Adobe. There is now a brand new website. Or what people think is a brand new website. Because IMHO, the site was just a jazzed up macromedia.com.

I hope Adobe will take care of us like Macromedia used to.

There is a great article on web security at ColdFusion Muse. This is part of a series of security articles you have got to read. I think it is best to secure out applications now before it gets too late. You never know when the hackers would strike.

Like I have discussed before, I have been banging my head against the table (I mean it!) on a project I am working on presently. This project involves writing fancy reports against very nasty databases. One, they are as old as my late grandfather (the oldest among the two) and two, the data is all messed up.I am writing more code to circumvent thrash data than to present the application itself.

I have tried some magic using CFMX query of queries but I guess that provide only dumd ass results. I remembered that while at my former work place, some fancy dude has connect the main Oracle DB to SQL server before as linked server. On I went to the net looking for resources. Now, DB2 is not a terribly popular database (It is mostly used by high-end enterprise organizations) not to talk of  a legacy version.

Anyway, after about a million years of trial by error, and a million pages of internet materials, I was able to link the two together. But my queries still won’t run with the four part notation (linkserver.catlog.schema.object). I tried and tried until I discovered that a bug on SNA server (corrected on service pack 4) doesn’t allow four part notation on DB2. So I finally settled down to the OpenQuery() method.

And to thrill my colleagues, I ran a query inner joining an EXCEL worksheet with a DB2 table….

I can now go home and sleep in peace.