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.htmOr 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
In the beginning, there was a command prompt, and all was well.