[Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.

TheMSsForum.com: The Microsoft Software Forum

Microsoft OLE DB Provider for ODBC Drivers
error '80004005'

[Microsoft][ODBC Visual FoxPro Driver]Cannot update the
cursor.

/_asp/test.asp, line 11

It's been a week now figuring out how to solve this
problem ("cannot update the cursor"). I am using IIS 5.1
in Windows XP Professional and Visual FoxPro ODBC Driver
(6.01.8629.01). System DSN is configured properly. I
never have this problem before when I was using IIS
4.0/5.0 in NT 4.0 and Windows 2000 Professional OS.

Any suggestions? Thanks in advance.

Here's the code for reference:
<% language="VBScript"%>
<!-- #include file=../_inc/adovbs.inc -->
<html>
<head><title></title>
</head>
<body>
<%
Dim oConn
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("DSN=UNR;UID=sa;PWD=pwd")
oConn.Execute("UPDATE nursegen SET FNAME = 'XXXX' WHERE
imgcode = '0000000001'")
oConn.Close
Set oConn = Nothing
%>
Top

Re: [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor. by Edhy

Edhy
Mon Sep 15 19:14:52 CDT 2003

Arnold,

Make sure any of the files are not read only.

--
Edhy Rijo
Programming System Solutions www.progytech.com
Bronx NY
"Arnold H." <arnoldfh@yahoo.com> wrote in message
news:485501c37bcf$86be48d0$a601280a@phx.gbl...
> Microsoft OLE DB Provider for ODBC Drivers
> error '80004005'
>
> [Microsoft][ODBC Visual FoxPro Driver]Cannot update the
> cursor.
>
> /_asp/test.asp, line 11
>
> It's been a week now figuring out how to solve this
> problem ("cannot update the cursor"). I am using IIS 5.1
> in Windows XP Professional and Visual FoxPro ODBC Driver
> (6.01.8629.01). System DSN is configured properly. I
> never have this problem before when I was using IIS
> 4.0/5.0 in NT 4.0 and Windows 2000 Professional OS.
>
> Any suggestions? Thanks in advance.
>
> Here's the code for reference:
> <% language="VBScript"%>
> <!-- #include file=../_inc/adovbs.inc -->
> <html>
> <head><title></title>
> </head>
> <body>
> <%
> Dim oConn
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.Open("DSN=UNR;UID=sa;PWD=pwd")
> oConn.Execute("UPDATE nursegen SET FNAME = 'XXXX' WHERE
> imgcode = '0000000001'")
> oConn.Close
> Set oConn = Nothing
> %>


Top

Re: [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor. by kurt

kurt
Tue Sep 16 09:03:51 CDT 2003

You may be having a user rights issue. When you access a web page ,
you are doing it using an anonymous user with the name defined in the
IIS Admin.

If you go to Programs -> Administrative Tools -> Internet Services
Manager, then right-click on default web site and select properties.
Then Click on the directory security tab and click on the edit button
in the anonymous access... section, you should be able to determine
the username.

Once you have that , make sure that guy has read/write privileges to
your fox tables, memo fields and indexes.


On Mon, 15 Sep 2003 14:22:54 -0700, "Arnold H." <arnoldfh@yahoo.com>
wrote:

>Microsoft OLE DB Provider for ODBC Drivers
>error '80004005'
>
>[Microsoft][ODBC Visual FoxPro Driver]Cannot update the
>cursor.
>
>/_asp/test.asp, line 11
>
>It's been a week now figuring out how to solve this
>problem ("cannot update the cursor"). I am using IIS 5.1
>in Windows XP Professional and Visual FoxPro ODBC Driver
>(6.01.8629.01). System DSN is configured properly. I
>never have this problem before when I was using IIS
>4.0/5.0 in NT 4.0 and Windows 2000 Professional OS.
>
>Any suggestions? Thanks in advance.
>
>Here's the code for reference:
><% language="VBScript"%>
><!-- #include file=../_inc/adovbs.inc -->
><html>
><head><title></title>
></head>
><body>
><%
> Dim oConn
> Set oConn = Server.CreateObject("ADODB.Connection")
> oConn.Open("DSN=UNR;UID=sa;PWD=pwd")
> oConn.Execute("UPDATE nursegen SET FNAME = 'XXXX' WHERE
>imgcode = '0000000001'")
> oConn.Close
> Set oConn = Nothing
>%>

Top

Re: [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor. by Brett

Brett
Fri Oct 10 09:43:57 CDT 2003

Make sure the table is not included in the build (right
click in project manager and uncheck Include).


>-----Original Message-----
>Arnold,
>
>Make sure any of the files are not read only.
>
>--
>Edhy Rijo
>Programming System Solutions www.progytech.com
>Bronx NY
>"Arnold H." <arnoldfh@yahoo.com> wrote in message
>news:485501c37bcf$86be48d0$a601280a@phx.gbl...
>> Microsoft OLE DB Provider for ODBC Drivers
>> error '80004005'
>>
>> [Microsoft][ODBC Visual FoxPro Driver]Cannot update the
>> cursor.
>>
>> /_asp/test.asp, line 11
>>
>> It's been a week now figuring out how to solve this
>> problem ("cannot update the cursor"). I am using IIS 5.1
>> in Windows XP Professional and Visual FoxPro ODBC Driver
>> (6.01.8629.01). System DSN is configured properly. I
>> never have this problem before when I was using IIS
>> 4.0/5.0 in NT 4.0 and Windows 2000 Professional OS.
>>
>> Any suggestions? Thanks in advance.
>>
>> Here's the code for reference:
>> <% language="VBScript"%>
>> <!-- #include file=../_inc/adovbs.inc -->
>> <html>
>> <head><title></title>
>> </head>
>> <body>
>> <%
>> Dim oConn
>> Set oConn = Server.CreateObject("ADODB.Connection")
>> oConn.Open("DSN=UNR;UID=sa;PWD=pwd")
>> oConn.Execute("UPDATE nursegen SET FNAME = 'XXXX'
WHERE
>> imgcode = '0000000001'")
>> oConn.Close
>> Set oConn = Nothing
>> %>
>
>
>.
>
Top