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.