Hi,

I am trying to change the name of the default database in the Chapter 10 Appointment booker.
I change the database name in Solution Explorer, then make an identical change in the Web.config file.
When I then try running the application, (on the local machine) I am unable to login.
Is there a correct procedure when changing the ASPNETDB name?

Thanks,

Lawrence.

Hi there,

The database in the App_Code folder (ASPNETDB.MDF) has been created by .NET for you automatically. Once this database has a different name, you also need to override the configuration settings for this database.

You either need to <clear /> or remove the existing one then add a connection string called LocalSqlServer andd give it the new settings.
In your connection string settings:

<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionstring=" Your conn string to the database" />

Alternatively, you can completely override the configuration for the providers. For an example of this, look in the web.config file for the BugBase application (chapter 12)

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.

Imar,

Thank You very much for the advice, that's a great help.

Lawrence.

You're welcome.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.