Shopping Cart works on Local Sys, but fails on IIS
I have an application I wrote using ASP.NET 2.0 book as a guide for a shopping cart function. I have everything working great on my local system using SQL 2005 Express. When I move the app to an IIS 6.0 Web Server with SQL 2005 Express installed I get the following error.
Line 103: Public Overridable Property Cart() As Wrox.Commerce.ShoppingCart
Line 104: Get
Line 105: Return
Line 106: End Get
Line 107: Set
It has some comments up top about not being able to establish a connection
to the SQL Express Database. I have made the changes to allow TCP/IP and
The App has to be connecting to the database because it displays grid views
during the order process.
The Database is located in the App Data folder
IIS is set to Integrated Authentication and configured as a Web Application.
web.config is setup to impersonate
Can someone please tell me what is wrong.