executenonquery

[nswan]

Hi,
I really shouldn't be getting stuck on this as I've used it before and even helped someone on these forums before with a problem like this but i just can't sort it!
I am getting 'Operation must use an updateable query' error.


sSQLPageHit = "insert into tblHits([page], [referer]) VALUES('nick','bob')"
myConnection.Open()
Dim myCom As New OleDbCommand(sSQLPageHit, myConnection)
myCom.CommandType = CommandType.Text
myCom.ExecuteNonQuery()
myConnection.Close()


Please help i am pulling my hair out!!

Nick

[nswan]

looks like i need to look at impersonation

[pvb]

Here's a link (http://forums.devshed.com/t65143/scd1523199a65343ad57c6575cd39277f.html) I found searching these forums for your error. I just skimmed it but it looks like you might need to make sure IUSR_ or the ASPNET account(depending on your OS version) can read/write to the directory your database resides. That includes both IIS and Windows security I believe. Search these forums for your error, lots of stuff came up.