Accessing Remote FoxPro table

In a nutshell, I'm trying to access a FoxPro table in a Classic asp
application that is located on another server, but I'm getting the
[Microsoft][ODBC Visual FoxPro Driver]File 'table.dbf' does not exist. I'm
in the process of upgrading to a new machine, but was able to get it to work
with the old one. The old machine is a Win 2000 server with IIS 5. This is a
intranet server, and security was not a huge concern, so the only way I was
able to get it to work was by doing the wrong things. Anyway, IIS is
configured to use the domain administrator account for Anonymous access. I
also used the domain administrator account for IIS Out-of-Process Pooled
Applications. Does IIS use any other account or does it need to be set in
multiple locations? I was able to use the same DSN in a vbscript
environment, so I know it has to be in the IIS environment that is causing
the issue.

Below is an example of my file DSN:
[ODBC]
DRIVER=Microsoft Visual FoxPro Driver
UID=
Deleted=Yes
Null=Yes
Collate=Machine
BackgroundFetch=No
Exclusive=No
SourceType=DBF
SourceDB=g:\WORKAREA\LOOKUPS

G: is a mapped drive on another server

Thank you,

Matthew

Re: Accessing Remote FoxPro table

Nevermind all...I got it, you have to use the UNC path

\\server\volume\directory\

"Matthew Laping" wrote in message
news:Ob46MoDoGHA.4728@TK2MSFTNGP03.phx.gbl...
> In a nutshell, I'm trying to access a FoxPro table in a Classic asp
> application that is located on another server, but I'm getting the
> [Microsoft][ODBC Visual FoxPro Driver]File 'table.dbf' does not exist. I'm
> in the process of upgrading to a new machine, but was able to get it to
> work with the old one. The old machine is a Win 2000 server with IIS 5.
> This is a intranet server, and security was not a huge concern, so the
> only way I was able to get it to work was by doing the wrong things.
> Anyway, IIS is configured to use the domain administrator account for
> Anonymous access. I also used the domain administrator account for IIS
> Out-of-Process Pooled Applications. Does IIS use any other account or does
> it need to be set in multiple locations? I was able to use the same DSN in
> a vbscript environment, so I know it has to be in the IIS environment that
> is causing the issue.
>
> Below is an example of my file DSN:
> [ODBC]
> DRIVER=Microsoft Visual FoxPro Driver
> UID=
> Deleted=Yes
> Null=Yes
> Collate=Machine
> BackgroundFetch=No
> Exclusive=No
> SourceType=DBF
> SourceDB=g:\WORKAREA\LOOKUPS
>
> G: is a mapped drive on another server
>
> Thank you,
>
> Matthew
>
>