connecting to remote visual foxpro database

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
psmshankar
Forum Commoner
Posts: 96
Joined: Tue Aug 06, 2002 4:25 am
Location: India

connecting to remote visual foxpro database

Post 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:
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post 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..
psmshankar
Forum Commoner
Posts: 96
Joined: Tue Aug 06, 2002 4:25 am
Location: India

Post 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????
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post by Stoker »

then I guess you need an ODBC-ODBC bridge or something... check openlinks generic drivers
Post Reply