So I'm trying to evaluate DB2/Connect - and in particular, IBM's JDBC driver that ships with it.
I've successfully configured and verified the datasource. But I can't seem to run any queries. I get this very mystic error: DB2 SQL error: SQLCODE: -805, SQLSTATE: 51002, SQLERRMC: DSN.NULLID.SYSLH200.5359534C564C3031;DISTSERV;04 SQLSTATE 51002 is apparently "Invalid column number" but... it happens with any query I try to run. Even: "select 1 from sysibm.sysdummy1" My JDBC URL is : jdbc:db2://sysa.adm.duke.edu:5010/DSN My Driver Class is : com.ibm.db2.jcc.DB2Driver Like I said, the datasource verifies but I can't run any queries. Thanks for any suggestions out there. 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:254547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
