VS 2005 + MSSQL question

[nitrobass24]

I have been using VS 2005 and I moved my solution to a network share so I could use any computer at my house to work on the solution.

However it now says it cannot connect to my database.
Its pointed at the network path but for some reason it cannot connect.

can anyone shed some light on this?

i get this error

The file "\\casey2\stu\Stephen_Davis\Visual Studio 2005\Chapter7\App_Data\chapter7.mdf" is on a network path that is not supported for database files.
An attempt to attach an auto-named database for file \\casey2\stu\Stephen_Davis\Visual Studio 2005\Chapter7\App_Data\chapter7.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

 

[generelz]

The error seems pretty self-explanatory to me. MS SQL will not run a database where the main data file is on a network share.

Why? Probably because this would lead to absolutely horrible performance.

 

[mikeblas]

Network locations for database files aren't supported by SQL Server because locking doesn't work [well enough] and network file access doesn't give good enough transactional and consistency guarantees.

 

[Monkey God]

this is a case where the error is to detailed for the user, which is unusual for microsoft.