Remote DB won't update

I don't know if I should post this question here or in the asp forum. Feel free to move it if this isn't the right spot.

I have been testing my site on my local machine and then put it on the server when things are the way I want them. Some of the pages involve updating a couple of databases. Everything works good when its on my machine, but when I put it on the server, it appears that everything works, until I looked at my database. Nothing got updated. So I put an on error resume next around the update function, and what got outputted was that the ODBC couldn't update the cursor.

I have the recordset.cursor set to 3(i forget what setting that is) and the DSN is set up on the server. None of the DB are read-only. I've gone into IIS and changed all the tables I want to written to read/write. I don't know what else to do. Any thoughts??

What database are you having problems with? Are you sure your DB user has enough permissions to update the tables?

I'm using Visual FoxPro. How would I go about checking permissions?

Thanks for the the reply.

I got to work today and I think I got the permissions changed on the .dbf. The permission for the IUSR_compName needed to be set to Full Control, right? I did that but still no go.

I don't know if this matters or not, but the account is not just IUSER_compName, but rather compName\IUSR_compName.

If thats alright, then I did that, but it still doesn't work. Any other suggestions?

I don't know how Foxpro authenticates, maybe there is some more help to be found in one of the database forums.

I don't believe this is an IIS problem, it sounds like a DB authentication problem.