ASP.NET inbuilt SQL CONNECTION in IIS?

ApurvA

New member
JAI MATADI . .

hello .. i m working in IIS Version 5.1

and in IIS i m working in ASP.NET 4.0 and i m creating my all files in C:\Inetpub\wwwroot\myfolder
and its working fine till i have used IN BUILT SQL DATABASE in it ..

i have made a simple INSERT INTO query through code in my SQL DATABASE ..
but i m getting the below alert after clickin the INSERT BUTTON ..

ERROR...
----------------------------------------------------------------------------------------------------
Unable to open the physical file "C:\Inetpub\wwwroot\asp.net simple\App_Data\Database11.mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)".
An attempt to attach an auto-named database for file C:\Inetpub\wwwroot\asp.net simple\App_Data\Database11.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
----------------------------------------------------------------------------------------------------

wht should i do ..
and yup as per the ERROR says ..

my database name is not the same as i have re created it with the other name

and i have also closed all the processes b4 opening it ..

still the same .. please let me knoww ..
hey another thing i have noticed is that when i m tryin to run my page through F5 the database working fine as i m able to insert my data in it ..

but when i m tryin to open it through IIS its getting the above error ..
I have closed everything my full ASP.NET ..

and then tryin to insert my data into this database but m getting this error noww . .

-------------------------------------
Failed to update database "C:\INETPUB\WWWROOT\ASP.NET SIMPLE\APP_DATA\DATABASE11.MDF" because the database is read-only.
-------------------------------------

but i seen everything by rite clikin on that related folder and unchecked the READ ONLY but still the same error occuring ..
 
Back
Top