Visual Studio Installation Express

Hot Topic

How do I change DateTimePicker default date?
starting another application with parameters
On the right track?
MSDN Tutorial Problem
Installation problems
Help with KeyDown or KeyPress
Help with databases
getting the free visual basic ebook
What have I done wrong?
how to code to make application icon goes to WINDOWS notification area when "minimize" is clicked in c#.net 2005 ?

VS Express Editions

error help plz
Newbie: Form problems
Office 2000 has VB Installer / Configuration Problem after installing VB Express 2005
How to make the setup.exe to deploy my application into a specific directory?
New Project dialog box
ReportViewer Problems
Books, tutorials of VC++ Express Edition for newbies
Launch IE and input data
i got C++ and new to programming. please tell me wht to do
An error occured while creating the new data source

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

  • Shyam Sundar

    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.

  • GentleWarrior

    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

  • shanzy

    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.



  • Mark Liu

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

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

  • prasliv

    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