Unable to open the physical file "C:\my\Apps\mydb.mdf". Operating system error 32: "32(The file is in use by another process.)".
\
Thanks
Looks like you are using SQLExpress and in your web site, web.config file you are directly attaching a dbf file, so it is getting used by ASP.NET worker process. But again you are trying to access it through reporting services, which is another process. So that is why you are getting this exception.
Try to modify your connection string, instead of AttachDB file name, build a proper connection string to SQL Express
|||I change my connection string to:
<connectionStrings>
<add name="DBCSCompany" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=true;Database=C:\Inetpub\wwwroot\apps\App_Data\Database.mdf" />
</connectionStrings>
but I still get the same error
|||Hi,
First, be sure that the physical path of the mdvb file is correct, I suggest that you shoud put your mdf file in app_code directory. so you can use "AttachDBFilename=|DataDirectory|someMdfFile"to locate the mdf file.
Second, when this problem occurred, just to check if other program is using the mdf file. Such as Visual Studio developpment server. If so, turn it off and try again.
Thank.
