Hi Dave, > I don't have anything helpful to offer, so pardon me in > advance for asking, > but why would you want to use a Type 2 driver if you have a > working Type 4 driver? > > Dave Watts, CTO, Fig Leaf Software
And I'm certainly no expert in this area, but here is how it was explained to me by one of our DB2 people: JDBC Type 2 drivers are a combination of Java code and native code and therefore are more efficient and provide top performance. JDBC Type 4 drivers are pure Java and allow direct connection to the database (presumably without having to have DB2 Connect installed) but are not as efficient. This position is pretty much supported by this article: http://www7b.software.ibm.com/dmdd/library/techarticle/0203zikopoulos/0203zi kopoulos.html George [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

