Deployed a site in iis, unable to perform insert function in the db

Question

Hey all,

I just deployed my site in iis and was testing it, while performing the insert operation I'm getting the following error

Failed to update database because the database is read-only.

what could i possibly do to overcome it????

hariom · Answer

it is related to database connection path. first u have to make virtual dirctory for ur website then chek it on local then u have to deploy the website and put proper connection string path.

Amit Choudhary · Answer

hi rujuta send me your files i'll apply the JQuery and message box code for you. my email id: vendett_amit@rediffmail.com

Rujuta · Answer

I tried jQuery but its not working at all....... any other ideas????

Amit Choudhary · Answer

Hi rujuta... sorry, it's because of site have changes it its structure.. you can found the article here: http://www.c-sharpcorner.com/UploadFile/vendettamit/JQuerymessageboxes12012009234120PM/JQuerymessageboxes.aspx

Rujuta · Answer

Thanks Amit, but I've already tried the client side message box, it doesn't work. I've to use it in masterpage. and your link isn't working....

Amit Choudhary · Answer

hi rujuta, well i don't wat's going on with your Sql Server 2008? what are new policies associated while creating and using new database in SS2008. but i can solve your message boxes problem. the message box you are using are only used for development purpose not for hosting purpose. Cause your message box are coming from server side they will appear only at server when you host the site on IIS server at another location. you have to use client side message box. you can use javascript alert message box for messages. RegisterClientScriptBlock("myAlert", " alert(' This a Message'); ") ; like this. But this is not much eye catching so you can user jquery message box. that is used for client side message box. Here is my article on Jquery message box: http://www.c-sharpcorner.com/UploadFile/vendettamit/JQuerymessageboxes12012009234120PM/JQuerymessageboxes.aspx?ArticleID=d86af8af-9cf3-42ed-af68-7de95cee5d85 Please mark as answer this post i know your half problem has been solved.

Rujuta · Answer

I was using express version of SQL Server 2008, there was a problem in the permissions. But now I have another problem I have a messagebox which works fine in the development environment but won't work once deployed to iis. I'm using VS2008(again an express version!). Don't know how to get the messagebox working. Any Ideas???

Amit Choudhary · Answer

hi Rujuta, Please give details about your database. Is it a Database file or Database connection?? and also paste your connection string here.. so that i can have more idea regarding problem.

Deployed a site in iis, unable to perform insert function in the db

Answers (8)