It's expensive, but you will really need it as your web applications expand. I mean doing things like changing passwords, creating users; any security management needs to have newer drivers to expose the functionality to CF. Otherwise you're stuck using ACF2 for all of that.
Also, we've seen a pretty significant performance increase using the Type 4 drivers. Have you looked into Shadow Z Direct at all? It's another expensive database connector, but probably the best around. On your original post, wouldn't that be a DB thing? I mean, I don't think that CF knows what column names are returned, just whatever the DB tells the CF server their names are. Man, 5.2, we're at least on 7 something :) > -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 27, 2006 11:03 AM > To: CF-Talk > Subject: Re: DB2 mainframe queries still not working properly! =( > > loathe wrote: > > That is pretty weird. We work on an Air Force system with CF MX 7 and a > DB > > 2 z/OS mainframe DB. > > > > We're using the type 4 drivers that ship with DB2 Connect and not seeing > > this problem. What driver are you using? > > Shoot, I mis-read... I see you're using the DB2 Connect drivers.. we're > using the JDBC driver that ships with Coldfusion. > > Shoot, I was really hoping *NOT* to have to purchase DB2 Connect, > because we don't own a current version (our version of DB2 Connect is > 5.2 and there are no JDBC drivers with it). IBM wants to charge us like > $60k for DB2 Connect version 8. > > Not really part of our budget! > > Rick > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254388 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
