Re: VFPOLEDB returning "Cannot update the cursor" by John
John
Fri Jan 02 08:18:20 CST 2004
Thanks, again! The problems do seem related to IIS. I've been wrestling
with various other issues with it as well. Looks like I'm going to have to
learn more about it than I had hoped!
- John
"Altman" <NotGiven@SickOfSpam.com> wrote in message
news:#UfvEYwzDHA.2148@TK2MSFTNGP12.phx.gbl...
> OK I know very little about IIS stuff so I won't pretend to be an expert,
I
> would think that IIS is causing the issue though. Try testing this with
the
> database in a different location and see if you can run it. If you can
then
> you know for sure that it is a problem with IIS. I would think it's
> something to do with security and it is not letting you write to that
> location. For instance on a network if I have a folder named share and
try
> to access it from c:\share it works fine but if I have security on that
> share saying that there is only read access and I try to access that same
> folder by \\myComputerName\Shared
> I will not be able to access it. I think you might have the same issue
> here.
>
>
> "John Spiegel" <jspiegel@YETANOTHERSPAMHATERc-comld.com> wrote in message
> news:uLBMKvvzDHA.2676@tk2msftngp13.phx.gbl...
> > Hi and thanks for responding.
> >
> > The database is on a local drive. I'm pretty unfamiliar w/ OLE DB so
> hadn't
> > really thought about the connection string. I originally had no Mode
> value,
> > but have tried with "ReadWrite" and "Share Exclusive". Even w/ "Share
> > Exclusive" I get the same error. I'm pretty sure that setting the mode
> has
> > an effect as Share Exclusive gave "Cannot open file" when I first
> attempted
> > to open it while a VFP session had it.
> >
> > The dbc and table are located in a subfolder under the inetpub\wwwroot
> > folder. Maybe there's something in IIS trying to control that???
> >
> > - John
> >
> >
> > "Altman" <NotGiven@SickOfSpam.com> wrote in message
> > news:#s5T5LvzDHA.2224@TK2MSFTNGP09.phx.gbl...
> > > Well you can open the database as read only in your connection string
> but
> > I
> > > would think that you would have thought of that already other than
that
> is
> > > your database local or over the network. If it is over the network,
do
> > you
> > > have rights to write to that folder/file likewise if it is local, is
> there
> > > some type of security set on the database that cannot be written to as
> the
> > > user you logged in as.
> > >
> > > "John Spiegel" <jspiegel@YETANOTHERSPAMHATERc-comld.com> wrote in
> message
> > > news:eKuyFSuzDHA.1740@TK2MSFTNGP12.phx.gbl...
> > > > Hi all,
> > > >
> > > > (And sorry for the double post for any .NET group readers)
> > > >
> > > > I'm trying to write to a VFP table from a .NET program using OLE DB.
> It
> > > > returns 'Cannot update the cursor "cursor", since it is read-only.'
> The
> > > > table is not open by any other source at the time and it wasn't
> flagged
> > as
> > > > read-only in the OS.
> > > >
> > > > I'm pretty ignorant when getting into OLE DB. Is there a setting in
> the
> > > > driver that could be causing it? If so, direction as to where to
> > address
> > > it
> > > > would be great!
> > > >
> > > > TIA,
> > > >
> > > > John
> > > >
> > > >
> > >
> > >
> >
> >
>
>