Good reading, thank you! I've never heard of the p2p.wrox.com
before. However it did not solve the problem. I'm running Apache on
Windows 98.
Also, the <CFSET temp=CFUSION_DISABLE_DBCONNECTIONS("KWExcel", 1)>
command did not work, but thanks for that suggestion to.
What did work, was moving the file into the root directory of the
machine (and changing the DSN accordingly). Does anyone know if what the
limit on the number of characters in a directory name for this type of
thing is? It was somewhere between 120 and 130. I removed all spaces from
the path (by renaming directories so they had no spaces) and that had no
effect, so I anticipate that was not the problem.
At 11:24 AM 04/16/2001 -0700, you wrote:
>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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
