The situation:
I'm writing an app for a Linux (PHP) webserver which needs to speak to a Pervasive.SQL database (technically, the database from Sage Businessworks Gold v6) which sits on a Windows box. (Yes, groan, but it's one of those 'client has their entire life in this database and will not be removed with a crowbar' situations)
I've done some database work, but never before had to speak to a non-remote database.
Pervasive.SQL speaks 'ODBC' apparently, and my copy of PHP was compiled to enable UnixODBC support.
Question:
In order to get the app speaking to the Windows box's database, it seems like I need something like the 'ODBC-ODBC Bridge driver' installed -- server on the Windows box, client on the Linux box(
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html )
Is this correct? Or is there an alternative? GBP 700 seems an awful lot.
Also, I assume there's no problem having two distinct databases in play-- a local MySQL one which stores additional information, and this remote one (which is honestly being queried just to find out current inventory)?
Anything else I should know going in?
________________________________________________________________________
Check out the new AOL. Most comprehensive set of free safety and security tools, free access to millions of high-quality videos from across the web, free AOL Mail and more.
---------------------------------------------------
PLUG-discuss mailing list -
PLUG-discuss@lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
(text/plain)