John, OpenLink's Multi-Tier drivers can get you from Linux to MSAcess on Windows.
Mweb, I'd just use ODBC against MySQL for testing. There isn't any way to actually run an Access DB on Linux. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: John Lim [mailto:[EMAIL PROTECTED]] > Sent: Saturday, November 10, 2001 12:06 PM > To: [EMAIL PROTECTED] > Subject: Re: [PHP] 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 <[EMAIL PROTECTED]> wrote in message > 20011110104958.B3706@polaris">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." > > > > > > [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote in message > > > GMJD1G$[EMAIL PROTECTED]">news:GMJD1G$[EMAIL PROTECTED]... > > > 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: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > To contact the list administrators, e-mail: > [EMAIL PROTECTED] > > > > -- > > Never let your sense of morals prevent you from doing what is right > > Salvor Hardin , "Foundation" > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]