mdf files

Hello all

I do not yet have a hosting account here, but i'm thinking about it. I am currently with someone else but I am missing some very important functionality and I think it has it here but want to confirm.

I developed a site using VS2008 Team System. I have a section of the site that needs to be secure with login controls, sessions, etc. My data is in an access database (but dont have a problem using SQL Server). The login controls uses a SQL Express database by default that it has to talk to and authenticate with it, but this host doesnt support .mdf files, or have a way to attach them to the SQL server for me to use them. I noticed in the list of things in the hosting account here that there is an attach utility.

Is this the missing link that I'm needing here? The hosting here has everything and more for my needs, but this one thing is of the greatest importance.

Thank you for reading

pcdebb

 

Hi,
I created a Video that shows how and why most of this is done here.
Yes the Attach feature is very handy but be aware it only works with SQL Server 2005.
It should also only be used on a blank/new DB.
You can make a backup in your control panel here for any of the SQL Server DBs, very handy feature.
The Video with the links to additional resources is #3 on this page:
http://iis7test.com/webcasts/
Salute,
Mark

 

wisemx,

Firstly, thank you for replying. The #3 video is just what I was looking for. I dont have a problem moving the data from MSAccess to SQL Server, not a problem. Just the clarification I need to become a customer

 

Hello, I am having a little problem. I have an auto complete extender on my website which uses suggestions from a data Table in an mdf file which is included in my project on the server. My connection string is:
</o>
"Data Source=.\\SQLExpress; Integrated Security=True; User Instance=True ;AttachDBFilename=C:\\Users\\game_over\\Documents\\Visual Studio 2008\\WebSites\\Personal Web Site\\App_Data\\Database.mdf". </o>
When I build and run the program on Visual Studio 2008 on my local computer everything works correctly and my suggestion feature works. However when the exact files are copied to my remote website the feature does not work. (which I assume is because a connection is not established). Help?

Howard Sueing
Howard Univeristy

 

Hi,
The Data Source method you are using is for SQL Express, which is not support here.
You can however add a SQL Server 2005 addon and use the Control Panel Attach feature.

Would you like help moving up from SQL Express to a DASP SQL Server?
Salute,
Mark