RE: [PHP] Re: Faking MS Access on MySQL linux box
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 2000104958.B3706@polaris">news:2000104958.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 NTthen 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]
Re: [PHP] Re: Faking MS Access on MySQL linux box
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) SNIP My suggestion would be to change hosting companies due to their stupidity of using Access as a web database and not willing to offer anything more robust. -- 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]
Re: [PHP] 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. [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 NTthen 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]
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 2000104958.B3706@polaris">news:2000104958.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 NTthen 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]
