Were using the DB 2 connect JDBC type 4 drivers without having to have them bound or having this problem.
The DB2 instance is 7 something and the DB 2 client is 8 something. > -----Original Message----- > From: Rick Root [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 10:26 AM > To: CF-Talk > Subject: Re: IBM's DB2 JDBC Driver > > In order to get the IBM DB2 JDBC driver working properly, I had to run > the DB2Binder, according to the following instructions: > > http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/co > m.ibm.db2.doc.java/bjnkmstr165.htm > > I had to specify a collection, so my JDBC URL ended up being: > > jdbc:db2://HOST:PORT/DBNAME:jdbcCollection=JDBCPKG; > > Of course, for some reason, this didn't solve my problem with "SELECT > FOO AS BAR FROM TABLE" returning "foo" as a column name. > > So far, the only driver I've tried that doesn't have this problem is the > HiT JDBC/DB2 driver from HiT Software. > > 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:254616 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
