How To Use SQL Express In A Shared Hosting Environment

 

All--

Please help.

I have deployed my site to my shared host and I am getting the following RTE...

An attempt to attach an auto-named database for file... ..App_DataCommerceDB.mdf failed

...and I cannot find the issue.

Note that I have given Full-Permissions on root folder for the IUSR account and for the ASPNET account.

The full error message is below.

Anyway, do you have an suggestions?

My web hosting provider has advertised that they do support SQL Express 2005. What exactly do I need to ask them to do in order to get this working?

Please advise.

Thank you.

--Mark Kamoski

 

Server Error in '/mkamoski/S16' Application.
--------------------------------------------------------------------------------


An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file c:hostingwebhost4lifemembermkamoskiS16App_DataCommerceDB.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Source Error:

Line 88:  ''' <returns></returns>

Line 89:  Public Shared Function GetCart() As ShoppingCart

Line 90:   Dim rdr As IDataReader = ShoppingCartProvider.Instance.CartGetCurrentCart(GetUserName())

Line 91:   Dim cart As ShoppingCart = New ShoppingCart()

Line 92:   cart.Load(rdr)
 

Source File: c:hostingwebhost4lifemembermkamoskiS16App_CodeBLLShoppingCartManager.vb    Line: 90