> Are you using the "MS Access with Unicode Support" drivers? Or > are you using the "MS Access" drivers? > > If you are using the latter, you are making a bridge to ODBC > from JDBC and back again. Very much more overhead and, as per > MM best practice, ODBC bridges should not be used in a production > environment on CF6+ due to the overhead it introduces. > > The 'unicode support' drivers, on the other hand, are native. > Wouldn't surprise me to learn that they leave behind the memory > leaks that Access ODBC gifted to the world.
I don't think the MS Access w/Unicode driver is native. It talks to ADO instead of ODBC. The driver class is com.inzoom.jdbcado.Driver: http://archives.java.sun.com/cgi-bin/wa?A2=ind0204&L=servlet-interest&F=&S=&; P=95311 And as far as I can tell, it hasn't been updated since 2002. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223313 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
