how to use an mdf in App_Data with shared hosting

Posted by name on Stack Overflow See other posts from Stack Overflow or by name
Published on 2009-06-16T17:07:15Z Indexed on 2010/04/11 17:13 UTC
Read the original article Hit count: 399

Filed under:

app-data

|

mdf

|

sql-server

|

datadirectory

If I create a website that uses an mdf in App_Data with the connection string:

Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname; Trusted_Connection=Yes;

what do I need to do to run the site in a shared hosting environment? Do I need to copy the contents of my mdf to the main SQL Server engine of my host? Is there a way to use the non-SQLExpress engine of my host and still keep my mdf in my App_Data?

© Stack Overflow or respective owner

Related posts about app-data

I can't install using Wubi due to permission denied error

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I can't install ubuntu 11.10 inside my windows 7. It shows permission denied while installation. It gave a log file having the following data: 03-29 20:19 DEBUG TaskList: # Running tasklist... 03-29 20:19 DEBUG TaskList: ## Running select_target_dir... 03-29 20:19 INFO WindowsBackend: Installing… >>> More
Why didn't 12.04 install?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
Ok, so I've installed Ubuntu many times on my computer.. Normally on the same partition, and WIndows would always delete Ubuntu(I don't know how.. it just happens) if i go away from keyboard during boot and it chooses Windows automatically because I took to long. So i tried to reinstall again, but… >>> More
Wubi and Vista 64 bits can't work

as seen on Super User - Search for 'Super User'
First of all, I have posted this issue at Ubuntu Forum without success yet. Hello, I have downloaded "kubuntu-9.10-desktop-amd64.iso" and I have mounted it on my Windows Vista 64 bits Ultimate. I have downloaded wubi 9.10. The problem is when installing, it crash after few time. Here is the log… >>> More
Audio Recording with Appcelerator on Android

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to record audio and then send the file to a webserver. I am using Titanium 1.8.2 on Win7. The application I am woring on is both for Android and iphone and I do realise that Titanium.Media.AudioRecorder and Titanium.Media.AudioPlayer are for these purpose. Let's concentrate on android… >>> More
Problems with umlauts in python appdata environvent variable

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I can't find a correct way to get the environment variable for the appdata path in python. The problem is that my user name includes special characters (the german ae and ue). I made a workaround wit PyQt for Vista and Windows 7 but it doesn't work for XP Systems. Does anybody know the correct… >>> More

Related posts about mdf

Convert SQLExpress 2005 .mdf to 2008 .mdf ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I have a Visual Studio solution and an ASP.NET MVC project that uses an mdf sql express 2005 database file in the App_Data. I want to know how I can upgrade this file so it works for sql express 2008 ? Thanks >>> More
Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the project's folder. The problem is that the SQL Server… >>> More
Copy mdf file and use it in run time

as seen on Stack Overflow - Search for 'Stack Overflow'
After I copy mdf file (and his log file) I tries to Insert data. I receive the following message: "An attempt to attach an auto-named database for file [fileName].mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. When I copied the… >>> More
how to use an mdf in App_Data with shared hosting

as seen on Stack Overflow - Search for 'Stack Overflow'
If I create a website that uses an mdf in App_Data with the connection string: Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname; Trusted_Connection=Yes; what do I need to do to run the site in a shared hosting environment? Do I need to copy the contents of my… >>> More
Membership in ASP.Net applications - part 3

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This is the third post in a series of posts regarding ASP.Net built in membership functionality,providers,controls. You can read the first one post one here . You can read the second post here . In this post I would like to investigate how to use the Membership class methods to achieve the same functionality… >>> More