Chapter 18: Viewing Site at http://localhost

epc · November 14th, 2009, 01:27 AM

After completing the lab on pages 653-656 and viewing the site at http://localhost I clicked on a couple pages under Reviews and tried logging in and I received the following error message in my inbox:

"An attempt to attach an auto-named database for file C:\Users\Erich\Documents\Gateway\Beginning ASP.NET 3.5 VB\BegASPNET\Release\App_Data\PlanetWrox.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

I read online that is may have to do with my connection string. I posted this below as a reference.

<addname="PlanetWroxConnectionString1"connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirector y|\PlanetWrox.mdf;Integrated Security=True;User Instance=True"providerName="System.Data.SqlClient"/>

I verified 3 times that my file system configuration mirrored the books directions.

Any thoughts would be appreciated.

Imar · November 14th, 2009, 04:19 AM

Hi there,

Quote:

I verified 3 times that my file system configuration mirrored the books directions.

Not entirely, I think:

Quote:

C:\Users\Erich\Documents\Gateway\Beginning ASP.NET 3.5 VB\BegASPNET\Release\App_Data\PlanetWrox.mdf failed

Take a look at the parent folder of the site: a folder under *your* documents folder, something the IIS account is not allowed to access.

Repeat the configuration steps but store the site in a global folder, such as C:\BegASPNET\Release as instructed in the book or something more general such as C:\Sites\PlanetWrox.

Cheers,

Imar

epc · November 14th, 2009, 10:33 AM

Thank you Imar!

I am taking classes right now and I thought I could categortize my work by placing your books site within my own directory. I followed your steps and it works great now. Sorry for not following the initial directions.

Imar · November 14th, 2009, 10:54 AM

Great, glad it's working now.

Note: C:\BegASPNET is not a required folder. You can choose other lcoations as well, as long as you don't store them under your user account's folders somewhere....

Cheers,

Imar