Page 1 of 1

connecting to remote visual foxpro database

Posted: Mon Jun 30, 2003 10:53 pm
by psmshankar
Hi,

Server A - running mysql, PHP, windows
Server B - visual foxpro 3, windows

Server B has some data in visual foxpro database.
I have to write a progam in PHP which runs on Server A to connect to Server B's visual foxpro database to get some data and put in to mysql database in Server A.

I have installed visual foxpro drivers and i can only connect to local visual foxpro database as there is button to browse and select the .dbc file(database container).. how to select the remote batabase in Server B????

Any idea... :?: :roll:

Posted: Tue Jul 01, 2003 7:47 am
by Stoker
make sure PHP on server A has ODBC support enabled, create a ODBC-DSN on server A for the resource on server B..

I dont really know foxpro, if that is a ms-jet-to-file-only type thing (like access is) you may need a ODBC-ODBC link driver (like OpenLinks generic one) as there is no "engine" to take car of remote requests in a native way..

Posted: Tue Jul 01, 2003 7:38 pm
by psmshankar
yup forget to mention that thru ODBC only I connected. When creating DSN it asks for DSN name description etc then there is button to browse and select the .dbc file(database container).. but where i can select the remote batabase in Server B????

Posted: Tue Jul 01, 2003 8:03 pm
by Stoker
then I guess you need an ODBC-ODBC bridge or something... check openlinks generic drivers