>Bob,
>
do this.
>
>Let's take another, simpler example. Suppose *you* have a Win2K box with a VFP database on it (forget Unix for a minute). How can *I* specify a DSN using the VFP ODBC driver that gives me access to your d/b via an Internet connection? And NOT using a VPN. I can't figure out any way to do this. If your machine is on my local area net, it's easy using Windows domain/server/share notation to specify th VFP ODBC Driver's Data Source Path. But when all I have is your IP address I'm hooped (aren't I??).

That depends on your own security issues. and how your firewall is set up. if you have a fire wall.

If you mark the folder which holds the dbc/dbf's as shared, then the other windows machine can hit it, provided you have a static ip address for that machine, and that IP address is sitting on the internet.

the accessablity is based on NT user name password.

then once you can hit it,
from the command line in windows just do a \\216.xxx.xxx.xx if its found, then it prompts you for a username and password. once you are connected. then map the drive, and set up your dsn.

I do this all the time, over the internet, but then again I have static ip's at home at my office, and my firewall only allows in requests from MY home static ip's

sure its not quite setting up a vpn. but it is secure.(not encryped however).

but thats about the only way I can think of doing what you are looking for.

Bob Lee





>
>BTW, I access SQL stuff via ODBC in Perl all the time - my knowledge of Perl per se ain't the problem.
>
>Any further input greatly appreciated,
>
>-Arne
>
>>What you would need is a Unix, odbc driver, that was able to read a vfp dbf - dc.
>>
>>In my opinion if anyone would have such a thing
>>
>>Recital would
>>
>>You might check out this.
>>
>>http://www.recital.com/solutions_odbc.htm
>>
>>
>>Or there are some addins avail to perl, which do allow for reading dbf type files. (but what version) most likley fox base type files... which could work if your are going to create new ones anyway.
>>
>>
>>Just wondering why you dont have vfp write directly to the Mysql server, itself, and bypass the Dbc / dbf's alltogether. ?
>>
>>
>>one last thought is that codecharge.com has utilitys which write out web type scripts in perl, using odbc, from unix... It may not do what you want, but they do have a free demo, and you can look at the perl code generated and see how its done. they really have a handle on perl, and getting odbc type data using it.
>>
>>
>>Bob Lee
>>
>>
>>>
>>>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