>I have a data file on an NT Server that my web page is able to access.
>I'm running IIS4. I haev a remote work station that I would like to be able to connect to that .mdb file via ODBC. How would I have VFp access the data file with out having a mapped drive? I would like to be able to use the TCP/IP protocol which is running on my Server & Workstation already. Have I missed somehting here!
>I have the .mdb file configured on my NT Server ODBC setup,
>Which DSN would I use the System,User or File DSN ?
>Is there an example of what I'm trying to do somehwere that I could look at.
>
>Thank you
>
>Scott

Here's how we set up our system recently. Maybe you can benefit....

I set up IIS 4 on a member server in the domain. Used NT4 with Service Pack 5. Also downloaded and installed the current MDAC components with the current ODBC drivers, which requires IE5. Using ControlPanel / ODBC Administrator, set up a System DSN and set its path to the directory containing the data files directory. (Note that there is a choice between a free tables directory and a database directory.) Give the DSN a name that can be used by the .asp file to access it. If you are using anonymous FTP access, you will also need to enable anonymous access and define the anonymous user account under IIS.

If the data files are on the local machine, this should be enough for the server setup. If your data files are on a different machine on the network, be sure to UNCHECK the box for 'Fetch data in background' on the options section of the system DSN page. Otherwise, you won't be able to connect to it. (That one cost us a call to MS tech support!) Be sure the network data directory rights permit access by the anonymous user account.

I hope someone else can answer the VFP question.

Good luck...

Neil Preston
Network admin
National Recruiting Report
www.nrr.com