I have a win2000 IIS webserver that serves our ASP pages. I need a way to 
connect it to our foxpro database sitting on a remote server with a firewall in 
between the two. 

What is the best way to do this? OLE dB? ODBC? I have been scouring the web all 
day and cannot figure out how to accomplish this with having the tables on the 
webserver. Security is number one priority. Any code connection string examples 
would be much appreciated. I am at a loss at what to do.

Stats: VFP 7, ASP (soon to migrate to asp.net...but this is not for some time yet)

Thanks!

You say that "security is number 1 priority"

If so, then move a copy of the FoxPro database (sans any confidential
information) into the DMZ. The whole point of a firewall is to protect your
internal network. Opening a port on the firewall to allow a machine from the
untrusted network to access an internal machine is kinda dangerous if
security is so important.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Brendan Foley" <bpf6838@i...>
Subject: [asp_database_setup] help with setting up ADO connection


: I have a win2000 IIS webserver that serves our ASP pages. I need a way to
: connect it to our foxpro database sitting on a remote server with a
firewall in
: between the two.
:
: What is the best way to do this? OLE dB? ODBC? I have been scouring the
web all
: day and cannot figure out how to accomplish this with having the tables on
the
: webserver. Security is number one priority. Any code connection string
examples
: would be much appreciated. I am at a loss at what to do.
:
: Stats: VFP 7, ASP (soon to migrate to asp.net...but this is not for some
time yet)
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~