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
arne@synercom-edi.com "There are no absolutes but this one."
President, synercom/edi - Event Ticketing Solutions