The idea behind the driver is speed. It is definitely faster than CFHTTP - but it has it's own nuances obviously.
-mk -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 11:54 AM To: CF-Talk Subject: RE: Reading CSV files with the ODBC text driver > It should be unlocked - it's been uploaded by a CFFILE just before the > CFQUERY is run. Actually, if you uploaded it in the same request as the CFQUERY, it is probably locked by CF, so you won't be able to use it through ODBC (which runs as a separate process). Someone suggested using CFHTTP to read it, and in my experience that has often worked better than using ODBC, as unlikely as that might sound. 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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:269885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
