Re: Re: Faking MS Access on MySQL linux box

John, thanks for the link, but isn't it a bit of overkill in my case? What I need is to write PHP pages which manipulate a MS Access DB via ODBC, because this is what the hosting company makes available (and it's not going to change because of several reasons) So, I am looking for explanation on how to do ONLY the testing of suche pages on a STAND-ALONE Linux box. I want to run some DB engine on it which is accessible through ODBC, so that I can say "if my ODBC call was OK here, it will work also when I upload on the NT/IIS server, because the interface is the same". Keep in mind that performance is not an issue here. On the linux PC I would only do testing, and the site on the real server currently has ~4000 visits/month querying a DB with some hundreds of entries. What do you think? mweb On Sat, Nov 10, 2001 13:02:14 at 01:02:14PM +0800, John Lim wrote: > 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 > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net -- Never let your sense of morals prevent you from doing what is right Salvor Hardin , "Foundation"