Hi all,

On an MS network I can easily connect to a VFP d/b on another machine using ODBC by setting up a System DSN using the VFP ODBC driver (of course I can also just open files 'directly' but that's not important here). Why can I not (or am I missing something) access a VFP database on another machine over IP? The SQL driver supports this fine of course, but then it's a server and designed for that. Is there a way to do something like:

[in the VFP DSN driver config]

set the DSN 'Path' to: //209.100.100.100/ShareName/VFPDBName

Yes, I realize one could setup a VPN blah blah blah, but that's not what I'm asking. To distill it further, is there a way to access a VFP database on an NT box via an ODBC driver on a UNIX box over the Internet? I'm already using a solution where my unix box runs a Perl script that communicates with the VFP database via an intermediate MySQL file (which a VFP app communicates with in turn). What I'd like to do is get rid of the intermediate file -and associated processes - and have the script access the VFP d/b directly.

Any thoughts?

-Arne