I have a .NET permissions question............I'm not very good when it comes to server settings and configuration. I'm trying to write a .NET application for someone who has their site hosted through GoDaddy.com. The person I'm writing it for wants the data written to an Access Database that he uses. I would definitely prefer to write to his SQL Server, but for his needs and use, he wants it to go to Access.......

Anyway.........When I try to write to the database I get the following error message:

"Operation must use an updateable query"

I'm almost positive that the problem is that .NET must have permissions to the folder that the database resides in. I attempted to contact GoDaddy Support and after about 30 minutes of waiting, I was told that this would have to be done via FrontPage Extensions by logging into their control panel and adjusting the settings. I did and didn't find anything at all that I thought would correct this.

I don't think this is the right answer.............Could someone tell me what would have to be done to give .NET permissions to the folder that holds the Access database?

Thanks in advance,

MB

You need to have Write & Modify permissions applied to the folder where the Access DB resides.

ye a- it's the IUser account that need modify permiossions - or what is ti called in 2003 - aspnet service or something like that? Hep me someone

Before I began working on the site, the owner had a FrontPage Database Results Wizard writing/reading from the database. The db resides in the "fpdb" folder that FrontPage creates..........Does that folder still need additional permissions allowed to it?

Thanks again,

MB

In 2003, if you need write/modify, you need to add those perms to ASP.NET(MachineAccount) & Network Service. Everybody says that the first isn't necessary and that it's only there for legacy support, but I always add that anyway. IUSR won't help you w/ ASP.NET - only ASP.

Josh is correct on the permissions question. Also,



The moral of the story - tell them they should move their site to HostMySite.com. You would have gotten someone on the phone immediately and they would have been able to set the permissions in the time it took you to get someone on the phone from GoDaddy.

The permissions need to be set on the database and/or the folder the database resides in. Its preferred to put the permissions on the folder so that if you overwrite the database through FP or FTP the new copy will get the same permissions. In the above case you would have them put Write & Modify on the fpdb folder.

Trust me, if I could get him to move............I would.

Thanks for the help guys,

MB

Jamie's not lying here....HMS is great about this kinda stuff

I'd offer my services on the weekend as a saboteur, however ever since one of our competitors 'mysteriously vanished' while I was on vacation my boss has frowned upon me 'visiting our peers'.

<shrugs>

I was going through the posts to see if I could find something that fit my problem. This fits my problem with my local computer. I have a db that holds tables for dvds and books. I have an aspx page that can query the tables. When a certain dvd is clicked on by the user, it should take them to a dvd details aspx page. Then on that page, the user can request to borrow the dvd. They put their name in a text field and click submit. However, when I click submit on my local IIS server, I get the same error as mentioned above. It has been suggested to me to change the permissions on the folder but I don't seem to have access to that. I was told to have permissions setup in the security tab when I right clicked on the folder where the db resides. However, I don't see aspnet user to give permissions to.

I am also having trouble just getting the connection string to work with my uploaded pages here. I originally had all the pages written in cf and they worked just great with being able to see and update the database on my site here. Since all the cf pages have been written in asp.net I can't even connect to my db anymore. I have been dealing with support here and they said that the person that wrote the code needs to modify it. He originally had it up and running on his hosting company's site and it worked great. Everything fell apart when I uploaded to my site here. The person that wrote the code did a dll which I put into a folder called bin, and he did a web.config page that seems to be the problem. I have been trying to get this to work for a couple of days now. I don't want to feel like I wasted my money paying this guy to recode my pages.

The reason that I switched from cf to asp.net is because I am building my own servers and can't afford one CF license to run the site. I can post any code that anyone wants to see. Some please help me with these two problems or I will go insane and hate asp.net forever!!!!

Me and my friend got a domain (from godaddy.com ) for some fun website for dinner and all that. I coded in ASP.NET and I have tested the website on my server.

I uploaded the code to godaddy server but its giving same problem which you had.
[b]"Operation must use an updateable query"[/b]

I know its really common error but I could not change the permission. I tried to do it but all attempts went futile. :cry:

Could you please advice me because we have to launch the website this Friday?

Thanks for your help in advance.

Is the site with HostMySite or with GoDaddy? If the former, simply contact our support department at support@hostmysite.com and give us the page where we can see the error as well as the folder that your db is in. If it's with GoDaddy you'll have to contact them - good luck!