-
executenonquery
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.
Code:
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
-
looks like i need to look at impersonation
-
Here's a link 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.