Connection String Problem with Scott Mitchell Tutorials

Hi,

 I've been working through the Scott Mitchell Tutorials and have hit a bit of a snag.  I initially worked through the data access tutorials and built a sample application based upon Northwind, which worked fine.  This application uses a three-tier design, with an individual project for the DAL and another for the BLL.  I then decided to do the security tutorials, but instead of creating a separate application, I added the security tutorial pages to the original data access application.  This, now, involves me using two identical connection strings; one in the app.config file of the DAL project and another in the web.config file of the web application.

As I said, when I only had the data access pages in the application I could access them through the connection string in app.config and that worked fine, but when I added the security tutorials, I found that I could no longer access the data access tutorial pages.  Basically any page that uses the connection string in web.config works (the security tutorial pages), but those using the connection string in app.config don't (the data access tutorial pages).

 I've checked that both connection strings are identical and I've also made sure that the connection string in settings.settings is the same and they all check out.

Has anyone else came up with this problem?  The reason I ask is that I am wanting to use these tutorials to build an application for work (my first one) and I cannot seem to find a solution to this problem.  Any help would be greatly appreciated.

Best regards,

Mick

Source Click Here.