Questions in VFP7OLEDBExampleVB sample

Hi all,

I try to run VFP7OLEDBExampleVB sample application on accessing VFP7 data
using OLE DB from ASP.NET app, and I have a problem.

Retriving data works OK, but the code give an error when try to update.

The error is in the line

Dim VFP7UpdateCommand As New OleDbCommand(strUpdateSelect, VFP7Connection)

' Execute the command

VFP7UpdateCommand.ExecuteNonQuery() ' <-------- Line with error

' Close the connection

VFP7Connection.Close()

And the error is "Cannot update cursor"

I checked the Update SQL statement, and it seems OK.

Does anyone have a clue about what is happening?

Thank you.
Bogdan

Rick
Tue Sep 16 09:02:22 CDT 2003

Bogdan,
I guess I'd first make sure you are using the latest VFP OLE DB provider =
that was released last month - =
http://www.microsoft.com/downloads/details.aspx?familyid=3D0f43eb58-7a94-=
4ae1-a59e-965869cb3bc9&displaylang=3Den, but since I haven't done any =
ASP .NET work, I'm not sure of that particular error.

Rick

"Bogdan Zamfir" <ams_soft at pcnet dot ro> wrote in message =
news:uhvpdBCfDHA.3616@TK2MSFTNGP11.phx.gbl...
> Hi all,
>=20
> I try to run VFP7OLEDBExampleVB sample application on accessing VFP7 =
data
> using OLE DB from ASP.NET app, and I have a problem.
>=20
> Retriving data works OK, but the code give an error when try to =
update.
>=20
> The error is in the line
>=20
> Dim VFP7UpdateCommand As New OleDbCommand(strUpdateSelect, =
VFP7Connection)
>=20
> ' Execute the command
>=20
> VFP7UpdateCommand.ExecuteNonQuery() ' <-------- Line with error
>=20
> ' Close the connection
>=20
> VFP7Connection.Close()
>=20
> And the error is "Cannot update cursor"
>=20
> I checked the Update SQL statement, and it seems OK.
>=20
> Does anyone have a clue about what is happening?
>=20
> Thank you.
> Bogdan
>=20
>