SELECT OK, INSERT and DELETE Problems in Windows 2003

[Rogério Ricardo Santos]

Hi,

I´m not getting write, alter or exclude any register in my table.

Only read without problems.

What is happening ?

Generate the error:

Code = 500
"Cannot update the cursor ALUN, since it is read-only."

Is there some configuration in the Web.Config File ? Or is the problem
with host (IIS) ?

The database is the Visual FoxPro.

The connection is:

sSqli = "DELETE FROM alun WHERE registr = 1"

'Open the Connection
oConnectioni = New OleDbConnection("Provider=VFPOLEDB.1;data source=" &
Folder)

oConnectioni.Open()
oCommandi = New OleDbCommand(sSqli, oConnectioni)

oCommandi.ExecuteNonQuery()

oConnectioni.Close()

The read I get without problems. (SELECT)
I´m not getting alter nothing. (INSERT and DELETE)

The host is the Windows 2003

Thank you,
Rogério

E-mail: [email]rogerio.ricardo@uol.com.br[/email]





*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[Ray at]

[url]http://www.aspfaq.com/5002[/url]

Ray at home

"Rogério Ricardo Santos" <rogerio.ricardo@uol.com.br> wrote in message
news:eE1MdQxkDHA.4008@TK2MSFTNGP11.phx.gbl...

> 'Open the Connection
> oConnectioni = New OleDbConnection("Provider=VFPOLEDB.1;data source=" &
> Folder)
>
> oConnectioni.Open()
> oCommandi = New OleDbCommand(sSqli, oConnectioni)
>