(sigh) it was a long night. i got this to work too. i just needed to wait
for CF to drop all the locks on the excel file each time i tested a
configuration. i got it at last. ;)
-----Original Message-----
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 10, 2001 9:32 PM
To: CF-Talk
Subject: help with cfusion_disable_dbconnections?
is anyone using the 4.5.x command
CFUSION_DISABLE_DBCONNECTIONS("DSN","{0/1}") with Excel datasources? i need
to upload an Excel file using CFFILE, read the contents, populate a SQL
table, and repeat. Excel files get locked when read like Access, but there's
no comparable .LDB lock file like there is in Access. and i don't want to
wait 5-20 minutes or so until the lock on the Excel file is dropped.
after i query the Excel file, i disable the DSN for that file using:
<CFSET temp = CFUSION_DISABLE_DBCONNECTIONS("fw_xls",1)>
and enable it right away using:
<CFSET temp = CFUSION_DISABLE_DBCONNECTIONS("fw_xls",0)>
(fw_xls is the DSN)
yet when i try to access the datasource after i run that, i get the
following error:
Connections to the KEN_XLS datasource have been disabled by the
administrator.
which is partly OK be cause i *did* disable it. but i also *en*abled it too!
:)
any help is GREATLY appreciated!
--dylan
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
