Q: DSN over a network drive

From: JIM.H. (JIMH_at_discussions.microsoft.com)
Date: 12/15/04 

Date: Wed, 15 Dec 2004 13:35:02 -0800

Hello,
I use this connection string to connect *.dbf files:
Dim strConn As String = "Provider=vfpoledb.1;DSN=MyDSN"

I defined MyDSN as free table with the folder C:\myFolder and put
myTable.dbf in there, I am able to retrieve data. However when I point folder
to a network drive as H:\myFoder and put myTable.dbf in there, I get the
following message: ERROR [42S02] [Microsoft][ODBC Visual FoxPro Driver]File
'myTable.dbf' does not exist.

So it seems I could not get DSN point a dbf in the network drive, any idea?
Thanks,
Jim.

Relevant Pages

  • Re: Word mail merge data source
    ... Word on it) then there may be a problem if the folder containing the data ... Word builds a connection string. ... but just because a user has full admin rights does not necessarily ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)
  • Re: Word mail merge data source
    ... "Peter Jamieson" wrote: ... Word on it) then there may be a problem if the folder containing the data ... Word builds a connection string. ... superset of other users' permissions - for example, ...
    (microsoft.public.word.vba.general)
  • Re: Connection string issue when in a separate web.config
    ... permissions for the Secure folder. ... the indexer on .ConnectionStrings expects the name of the connection string, ... the Website->Asp.Net Configuration option in Visual Studio. ...
    (microsoft.public.dotnet.security)
  • Re: MS Access on IIS 5.0
    ... >having to modify each page. ... >problem which I have to fix but I think I can manage this ... >I moved the databases to another folder but now I can't ... you need to change the connection string to ...
    (microsoft.public.inetserver.iis.security)
  • Re: Database Location in a Multitier Soulution
    ... connection string. ... being in the App_Data folder anyway. ... When you create your data layer (I guess this will be in a separate class ... server. ...
    (microsoft.public.dotnet.framework.aspnet)