When you are giving path with the map drive, make sure it is 
accessed once after booting the server on which data resides pc. 
(When you open windows explorer and if u can see a red spot on the 
drive icon for that drive click it once so that the spot 
disappears)
But the best way to give path is by giving the whole path like 
//[servername]/drive/ .....
Hope your problem will be solved
Cheers
Bharat



On Wed, 03 Apr 2002 Henri-François Depouille wrote :
>Hi everybody,
>
>I have a big problem, and maybe, somebody will be able to help 
>me.
>When I access fox pro tables locally, there is no problem, but 
>whenever I try to acces DB located on another server, no way to 
>access them.
>I tried every method: ODBC and OLE DB. I also tried system DSN 
>and File DSN for the ODBC connection but it makes the same 
>error.
>
>
>
>Here are the error: (j: is a mapped drive)
>
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
>-
>
>1) with OLE DB:
>
>Session("oFLEX").open "DRIVER={Microsoft Visual FoxPro 
>Driver};SourceType=DBF;SourceDB=j:\sp\data;"
>
>---> here, the error is immediate, when I load the intranet:
>    Error Type:
>       Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
>       Invalid path or file name.
>       /intranet/include/init.inc, line 12
>
>|
>+---> line 12: Session("oFLEX").open ......
>
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
>-
>
>2) with ODBC:
>Session("oFLEX").open "Provider=VFPOLEDB.1;Data 
>source=j:\sp\data;"
>
>----> here, the error occurs ony when I open a table.
>     Error Type:
>        Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
>        [Microsoft][ODBC Visual FoxPro Driver]File 'hist.dbf' 
>does not exist.
>        /intranet/include/todos.inc, line 38
>
>|
>+---> line 38: Set oRS = session("oFLEX").Execute("select * from 
>hist")
>
>- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 
>-
>
>Is it possible to access fox pro tables located on another server 
>and if yes, how to do this?
>
>THANKS BEFOREHAND TO HELP ME
>
>HENRI
>
>
>_________________________________________________________________
>Discutez en ligne avec vos amis, essayez MSN Messenger : 
>http://messenger.msn.fr
>
>
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or to 
>unsubscribe send a blank email to 

a) NEVER store connection objects in session variables. You will kill the
scalability of your applications, and defeat connection pooling. Read this
to see what connection pooling is:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html
/pooling2.asp

b) Drive letters like "j:" are mapped for the *logged on* user only. Not for
any other user, in particular the user account that the web server is using
to access resourses (IUSR_<Machinename> by default). Instead you need to use
UNC paths \\server\share\folder\file

c) Remember (from (b)) that the webserver is using a different user context
(by default) to access resources - thus you need to give that user access to
the remote resources. Normally you can't do this as IUSR_<machiname> is
local to the webserver - you may need to either use NTLM authentication -or-
change the anonymous user account to a domain account that has permission to
the remote resource.

d) Please post only one copy of your message

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Henri-François Depouille" <hfdepouille@h...>
Subject: [asp_databases] Please HELP ME !!! :'( - - - - problems while
accessing remote fox pro tables


: Hi everybody,
:
: I have a big problem, and maybe, somebody will be able to help me.
: When I access fox pro tables locally, there is no problem, but whenever I
: try to acces DB located on another server, no way to access them.
: I tried every method: ODBC and OLE DB. I also tried system DSN and File
DSN
: for the ODBC connection but it makes the same error.
:
:
:
: Here are the error: (j: is a mapped drive)
:
: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
:
: 1) with OLE DB:
:
: Session("oFLEX").open "DRIVER={Microsoft Visual FoxPro
: Driver};SourceType=DBF;SourceDB=j:\sp\data;"
:
: ---> here, the error is immediate, when I load the intranet:
:     Error Type:
:        Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
:        Invalid path or file name.
:        /intranet/include/init.inc, line 12

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi everybody,

I have a big problem, and maybe, somebody will be able to help me.
When I access fox pro tables locally, there is no problem, but whenever I 
try to acces DB located on another server, no way to access them.
I tried every method: ODBC and OLE DB. I also tried system DSN and File DSN 
for the ODBC connection but it makes the same error.



Here are the error: (j: is a mapped drive)

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

1) with OLE DB:

Session("oFLEX").open "DRIVER={Microsoft Visual FoxPro 
Driver};SourceType=DBF;SourceDB=j:\sp\data;"

---> here, the error is immediate, when I load the intranet:
    Error Type:
       Microsoft OLE DB Provider for Visual FoxPro (0x80004005)
       Invalid path or file name.
       /intranet/include/init.inc, line 12

|
+---> line 12: Session("oFLEX").open ......

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

2) with ODBC:
Session("oFLEX").open "Provider=VFPOLEDB.1;Data source=j:\sp\data;"

----> here, the error occurs ony when I open a table.
     Error Type:
        Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
        [Microsoft][ODBC Visual FoxPro Driver]File 'hist.dbf' does not 
exist.
        /intranet/include/todos.inc, line 38

|
+---> line 38: Set oRS = session("oFLEX").Execute("select * from hist")

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Is it possible to access fox pro tables located on another server and if 
yes, how to do this?

THANKS BEFOREHAND TO HELP ME

HENRI


_________________________________________________________________
Discutez en ligne avec vos amis, essayez MSN Messenger : 
http://messenger.msn.fr