Visual Studio Installation Express

Hot Topic

Adding Stopwatch Class
Starter Kits are a nice idea - but in reality they are a huge waste of time
Service C# Express
If Statments
Arraylist and recursion problems
Unknown error "-1".
fatel error c1083
How do you insert a byte in a string (without expansion)?
Which files and directories do I need to commit to version control (CVS)?
container

VS Express Editions

Communicating to other apps...?
Installing Visual Web Developer problem
XML...add new XML elements to existing document
Registration & Localized builds
Windows Mobile 5.0 app
Treeview question #4
Extremely Illogical Error
what chose C# or C++
Using VB Express with a limited account
form.showdialog problem

Visual Studio Installation Express

Have just installed Visual Web Developer Express with SQL Express. Seemingly successfully

Running the program for the first time and creating a "personal website" a suggested produces this error on attempting to view the newly created site

"The file "\\fs01\Users\robin\My Documents\Visual Studio 2005\WebSites\WebSite3\App_Data\Personal.mdf" is on a network path that is not supported for database files."

My PC is part of a W2003 domain and the My Documents folder is redirected to the User's home network drive. I don't want to change this.

How do I place the database on a local drive

Any help would be much appreciated.

Answer this question

Visual Studio Installation Express

  • Webdav101

    Yeah, I think the op was looking to relocate on a local drive but it's good to know that Express is unsupported (by default) on a network share. Thanks for the KB article.

  • Omar Naeem

    SQL Server does not support NAS database file locations by default.

    See this Microsoft Support article: http://support.microsoft.com/default.aspx scid=304261

  • Fresh Mexican Food Fan

    Hi,

    Thanks for that. I looked at the SQL Server Manager it was not clear how to make this change. Also the error generated was that the Visual Web Developer Express program was try to create a DB on a network drive. So there isn't a DB to move yet! How do I change where Visual Web Developer Express is attempting to place its DB.

    thanks for your help.

    Robin

  • George Smith

    You should be able to use the SQL Server Express Manager to detach and attach when moving your database. There are also stored procedures that can handle this for you (sp_attach_db and sp_detach_db).

    You can also use the AttachDbFilename parameter in your connection string to specify the location of your database.



  • daiwen

    I haven't used Visual Web Developer Express but AFAIK the method is the same as in the other Express products. You can use the Data Explorer to create the new database in a specified location, or the SQL Server Express Manager.

  • Visual Studio Installation Express
Answer this question