Questions in VFP7OLEDBExampleVB sample

[Bogdan Zamfir]

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 Bean]

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/d...displaylang=en, 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:uh**************@TK2MSFTNGP11.phx.gbl...

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