RE: How to close Excel ODBC connection at end of query

2002-04-18 Thread VAN VLIET, SCOTT E (SBCSI)
What about the "Maintain database connections" setting for the DSN under ColdFusion Administrator? This should take off the lock place on the XLS file. I am not sure if this will work for your problem, but you might want to give it a shot. +--+--

RE: How to close Excel ODBC connection at end of query

2002-04-18 Thread BillyC
Perhaps you could build a COM object to access the data? (Since ADO gives you more control over when the connection is opened/closed) Or if you're good with COM in C++, you could build a CFX (gives you the advantage of being able to build a "cf" recordset) --- Billy Cravens -Original Mess

Re: How to close Excel ODBC connection at end of query

2002-04-18 Thread Jamie Jackson
il 2002 20:53 >To: CF-Talk >Subject: Re: How to close Excel ODBC connection at end of query > > > >Ray > >At 08:45 PM 4/18/2002 +0100, you wrote: >>Hi, >> >>Further to my problem of aparently retrieving cached query results when >>using an excel data

RE: How to close Excel ODBC connection at end of query

2002-04-18 Thread Dave Wilson
ow to close Excel ODBC connection at end of query Ray At 08:45 PM 4/18/2002 +0100, you wrote: >Hi, > >Further to my problem of aparently retrieving cached query results when >using an excel datasource (see earlier email titled Strange behaviour with >excel datasource), I've disco

Re: How to close Excel ODBC connection at end of query

2002-04-18 Thread Ray Bujarski
Ray At 08:45 PM 4/18/2002 +0100, you wrote: >Hi, > >Further to my problem of aparently retrieving cached query results when >using an excel datasource (see earlier email titled Strange behaviour with >excel datasource), I've discovered that CF seems to be keeping the ODBC >connection alive acros