I am new to ASP.NET 3.5 and learning through a standard book on the subject. I am very familiar with traditional ASP and developed several successful projects with database links.
I am using visual studio 2008 on XP Professional (SP3) to develop webpages and testing on the local host.
I created a SQL Server 2005 database (smdemo.mdf) from visual studio 2008 not from SQL server 2005 Management Studio.
The test site folder (asp24hr) is located on
I testing using the command: http://localhost/asp24hr/nameofaspx
The static pages are working fine. But the aspx file with database link is not working and giving an error
The error is
Unable to open the physical file "C:\Inetpub\wwwroot\asp24h
f". 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\asp24hr
failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
I have gone through the web forums on the subject. As per their instructions, I checked whether the mdf database file exists on Management Studio Express and login with an admin account. But I do not see that file in the list of databases. Any thoughts how to resolve the problem