This occurs in a could of cases:
-When trying to import a file that has a invalid or not matching extension
name. -Could be a bug with IIS 5. If you are running IIS 5 log in as
administrator and view/modify privileges on the server.
Check out:
http://support.microsoft.com/support/kb/articles/Q245/4/07.asp
http://p2p.wrox.com/archive/asp_databases/2001-02/98.asp
http://www.p2p.wrox.com/archive/beginning_asp/2000-09/11.asp
----- Original Message -----
From: "Jeffry Houser" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 1:59 PM
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
> >
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
