have you tried using:
<CFSET temp=CFUSION_DISABLE_DBCONNECTIONS("{DSN}", 1)> ?
i don't know if the Excel DSN is being locked, thereby preventing you from
accessing it, but that will force the DSN to be released. to re-enable the
DSN, use:
<CFSET temp=CFUSION_DISABLE_DBCONNECTIONS("{DSN}", 0)>
just replace {DSN} with your actual DSN with no {}.
-----Original Message-----
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 16, 2001 2:00 PM
To: CF-Talk
Subject: Excel and ColdFusion
I searched the Microsoft Knowledge Base
I searched the Allaire Knowledge Base.
I looked at CFCOMET (great site)
I searched the mailing list archives.
I searched through the developer's exchange, and downloaded some of the
tags.
I checked the FAQ
I still haven't found the answer I'm looking for, so I'm posting
here. I'm trying to set up something to read from an excel sheet. When I
run the template, I keep getting the error:
[Microsoft][ODBC Excel Driver] Cannot update. Database or object is
read-only.
I downloaded a SQL connector program from the Allaire KB. It connects
to the datasource just fine. I checked the datasource, and I have
deselected the read-only option. However, I have seen it reselect itself.
I'm on a windows 98 unit. This is the code in my test template:
<CFQUERY datasource="KWExcel" name="getsheet">
select *
from [test$]
</CFQUERY>
<CFOUTPUT>
#getsheet.recordcount#<BR>
</CFOUTPUT>
The code seems about as basic as you can get.
Any suggestions would be welcome.
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711 | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0 | ISBN: 0-07-213238-8
Due out June 2001
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Half of the Alternative Folk Duo called Far Cry Fly
http://www.farcryfly.com | http://www.mp3.com/FarCryFly
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
