Re: Re: Faking MS Access on MySQL linux box

Hi Mweb, yes it is overkill, but I don't know any other way to do it unless you want to buy a 3rd party odbc driver for Access on Linux (is there one?) Bye, John Mweb <mweb@inwind.it> wrote in message news:20011110104958.B3706@polaris... > 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"