Help - Operation must use an updateable query.

abhims · June 18th, 2008, 12:52 AM

I have put up an asp.net application on WINDOWS SHARED HOSTING.
Now the problem is my application is of no use beacuse the database requires write permissions to be updated, however my host says they cannot give write permissions due to security reasons, i will have to modify my code

what will be the solution to this problem

my application is in the "web" folder and the database is within the application's "App_Data" directory.

I have a "Database" folder in my websites root.

will using a dsn help me get out of this problem, if yes how do i modify the connection string for it

what are the other possible solutions

Thanks in advance

Rob · June 18th, 2008, 03:12 AM

I would not use the database directory, thats for sure - because it resides in your web root.

If you application throws a database error then the full path to it could be revealed.

The app_data directory may have write permissions set up for DSN accesses.

Personally, in this situation I would explain to your host that you need to access AND update your database -which method do they recommend.

If you need a DSN, then they will have to set that up for you unless you have a control panel to do that yourself.

We can help you with the connection string if you need, but I would definitly speak to your host firstly.

abhims · June 18th, 2008, 04:06 AM

Thanks for the response Rob!

I can add dsn with my control panel, i beileve it might solve the problem, but I dont know how to use the DSN connection string in the web.config file.

I have spoken to my host, they say that i will have to modify my code.

I would want to test the DSN way myself before I get back to them, so that i can put my issue in a strong way.

Thanks

Rob · June 18th, 2008, 04:14 AM

Hi, you need something similar to the following

Code:

<configuration>
    <appSettings>
        <add key="DSN" value="Server=(local);Database=DSNName;UID=sa;PWD="  />
     </appSettings>
</configuration>

Hope this helps.