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.