"Dave Mills" <News@nospam.djmills.co.uk> wrote in message
news:q7p7121iqu79oqi3t3e4ov4tdr4es6dam4@4ax.com...
>I hope this is the right group. There are so many to choose from.
>
> I am trying to work my way through the VS 2005/VB Express Guided Tour. I
> have
> not done any Database work with VB before.
>
> All is going more or less OK until now. I have completed the "MSDN
> Lib.../VB
> Express/Managing you records.../"Creating Your First Database" and
> populated the
> data. On the next lesson "Getting the Info You Need...." I have run into a
> brick
> wall.
>
> I create the new project but when I try to add a connection to the
> existing
> database (created in the previous exercise) I get an error
>
> "The file "\\server\docs\username\visual studio
> 2005\projects\firstdatabase\firstdatabase.mdf" is on a network path that
> is not
> supported for database files."
>
> The location IS a UNC path but it is the path that was used (by default)
> during
> the previous database creation exercise. This path is under My Documents
> and My
> Documents is a redirected folder to a server.
>
> I can understand that UNC paths might not be supported (I cannot find any
> documentation on this though) but if this is the case how was it able to
> work
> for the previous exercise when the database was created on the UNC path
> and
> populated with data.
>
> Can anybody clear up my confusion here.
>
> Dave
>
> --
> Dave Mills
> There are 10 type of people, those that understand binary and those that
> don't.

<billvaRemoveThis@nwlink.com> wrote:

>Nope, SQL Server won't attach to a UNC pathname. It has to be a physical
>path/filename on the local system--not somewhere on the net.