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.
+--+--
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
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
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
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
5 matches
Mail list logo