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 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.