RE: Reading CSV files with the ODBC text driver
Nick, Try putting a specific named lock around your CFFILE operation. I suspect CF has the file still locked. -Mark -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 11:36 AM To: CF-Talk Subject: Re: Reading CSV files with the ODBC text driver Mark Is the file unlocked and does the driver have permissions to access it? It should be unlocked - it's been uploaded by a CFFILE just before the CFQUERY is run. As regards whether the driver has permissions to access it - CF certainly has, but I don't know about the driver itself, if that's a separate issue - how do I tell? Thanks Nick ~| 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:269884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading CSV files with the ODBC text driver
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
RE: Reading CSV files with the ODBC text driver
The idea behind the driver is speed. It is definitely faster than CFHTTP - but it has it's own nuances obviously. I wouldn't be so sure about that. In my experience, using CFHTTP to fetch a CSV file and convert it to a query has often been faster than other approaches. I realize that doesn't make any sense, but there you are. 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:269886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Reading CSV files with the ODBC text driver
Hello everyone, long time time since I was here. I'm trying to read a CSV file with CFQUERY using the ODBC text driver as described at http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv. I get this error: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'C:\test\testfile.csv'. Make sure the object exists and that you spell its name and the path name correctly. It doesn't matter where I put the file, I always get this error. Windows XP, CFMX 7.0.2, MDAC 2.8, Jet 4.0 Service Pack 8. Any ideas? Thanks Nick ~| 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:269627 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading CSV files with the ODBC text driver
Have you tried using CFHTTP? It can also return a CSV/Text file as a query. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog Quoting Nick de Voil [EMAIL PROTECTED]: Hello everyone, long time time since I was here. I'm trying to read a CSV file with CFQUERY using the ODBC text driver as described at http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv. I get this error: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'C:\test\testfile.csv'. Make sure the object exists and that you spell its name and the path name correctly. It doesn't matter where I put the file, I always get this error. Windows XP, CFMX 7.0.2, MDAC 2.8, Jet 4.0 Service Pack 8. Any ideas? Thanks Nick ~| 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:269630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading CSV files with the ODBC text driver
Have you tried using CFHTTP? It can also return a CSV/Text file as a query. Thanks for the suggestion Matthew. I was hoping to get the CFQUERY approach working because presumably it's the most efficient, and I may have a lot of data to process. Nick ~| 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:269633 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Reading CSV files with the ODBC text driver
Thanks for the update Nick. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 8:59 AM To: CF-Talk Subject:Reading CSV files with the ODBC text driver Hello everyone, long time time since I was here. I'm trying to read a CSV file with CFQUERY using the ODBC text driver as described at http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv. I get this error: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'C:\test\testfile.csv'. Make sure the object exists and that you spell its name and the path name correctly. It doesn't matter where I put the file, I always get this error. Windows XP, CFMX 7.0.2, MDAC 2.8, Jet 4.0 Service Pack 8. Any ideas? Thanks Nick ~| 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:269640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Reading CSV files with the ODBC text driver
Nick, Is the file unlocked and does the driver have permissions to access it? -Mark -Original Message- From: Orlini, Robert [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 9:46 AM To: CF-Talk Subject: RE: Reading CSV files with the ODBC text driver Thanks for the update Nick. -Original Message- From: Nick de Voil [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 8:59 AM To: CF-Talk Subject:Reading CSV files with the ODBC text driver Hello everyone, long time time since I was here. I'm trying to read a CSV file with CFQUERY using the ODBC text driver as described at http://www.coldfusionmuse.com/index.cfm/2007/2/5/csv. I get this error: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Text Driver] The Microsoft Jet database engine could not find the object 'C:\test\testfile.csv'. Make sure the object exists and that you spell its name and the path name correctly. It doesn't matter where I put the file, I always get this error. Windows XP, CFMX 7.0.2, MDAC 2.8, Jet 4.0 Service Pack 8. Any ideas? Thanks Nick ~| 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:269661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading CSV files with the ODBC text driver
Mark Is the file unlocked and does the driver have permissions to access it? It should be unlocked - it's been uploaded by a CFFILE just before the CFQUERY is run. As regards whether the driver has permissions to access it - CF certainly has, but I don't know about the driver itself, if that's a separate issue - how do I tell? Thanks Nick ~| 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:269662 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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:269666 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Reading CSV files with the ODBC text driver
Dave 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). It's not the same request, but a subsequent request in the same session - do you think it would still be locked by CF? Is there a way I can see for myself if the file is locked and by what process? Thanks Nick ~| 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:269684 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading CSV files with the ODBC text driver
I'm surprised you would get a file not found error if the file was there but locked? Are you 100% sure the file exists at C:\test\testfile.csv ? -Ryan It's not the same request, but a subsequent request in the same session - do you think it would still be locked by CF? Is there a way I can see for myself if the file is locked and by what process? Thanks Nick ~| 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:269691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reading CSV files with the ODBC text driver
Ryan I'm surprised you would get a file not found error if the file was there but locked? Are you 100% sure the file exists at C:\test\testfile.csv ? Yes, 110%. Nick ~| 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:269705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Reading CSV files with the ODBC text driver
It's not the same request, but a subsequent request in the same session - do you think it would still be locked by CF? I wouldn't be that surprised, actually. Is there a way I can see for myself if the file is locked and by what process? If you're running on Windows, you can use the Sysinternals Filemon utility: http://www.microsoft.com/technet/sysinternals/FileAndDisk/Filemon.mspx 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:269714 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
