Re: Faking MS Access on MySQL linux box

See http://php.weblogs.com/adodb_csv "ADODB also supports SQL communications through HTTP as a database proxy. In plain English, if you have a FoxPro or Access database that you need to connect to from Unix, you can do so via HTTP (eg. Apache talking to IIS, which talks to a small PHP program [the proxy] that queries the database, packs it into serialized text and sends it back to Apache). PHP client -- Apache ------------ IIS -- PHP server -- Database Or if you have to go through a firewall to access your database, this solution allows you to stream SQL queries as HTTP through the firewall." Mweb@Inwind.It <mweb@inwind.it> wrote in message news:GMJD1G$IdrS2o7UJh3SrtqSB5YJTlra9pHkeHHMgJYyGfv0@inwind.it... Hello, For reasons not worth discussing here, I have to develop and test on Linux/Apache some PHP pages that will have to access via ODBC a MS Access database on an NT/IIS/PHP server. I would like to do it by writing PHP pages that access via ODBC some mysql or other database on my linux box, in such a way that, if it works there, I just change some general setting, upload the pages and they work for sure on the MS Access thing (something like: ifdef LINUX then ODBC_ACCESSES_MYSQL ifdef NT then ODBC_ACCESSES_MS_Access) I am sure that this must be possible, but would really appreciate some examples/pointers to specific tutorial/similar stories/etc. TIA, mweb