Ok, So we can connect just fine. I mean, DB2 Connect, and Neon are both around. Currently we only use Neon for user management stuff.
Here is the question. What is the best way from CF (potentially on a web sphere server) to have FULL access to DB 2. By this I mean user management, stored procedures, and regular SQL statements. The client wants to get rid of Neon as it is very expensive, and DB 2 Connect isn't as fast as it is. Is there a different third party driver or client that can do the same thing? Can I do user management through JDBC? I hear there are a ton of performance gains to be had by using JDBC, is this true? I have never had to connect to a mainframe before so this is all new to me. The DBA we have has always worked on mainframes and doesn't know a lot about much else, and isn't really all that helpful. Any way, TIA. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:247494 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
