Re: PHP connection to remote Access database on NT
| From: | James Hughbanks | Date: | Thu, 11 Sep 2003 05:13:22 +0000 |
| Subject: | Re: PHP connection to remote Access database on NT | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-30459@lists.php.net to get a copy of this message | ||
Yes, it is possible, but you will have to use an odbc connection on the linux box. I have heard of this being done, but never attempted to mysql, go to www.iodbc.org, that is the odbc software for linux, lots of articles on php+apache+odbc there.
--James
On Wednesday, Sep 10, 2003, at 21:55 America/New_York, John Almberg wrote:
Here's a question I hoped I'd never have to ask... Is it possible for PHP, running on a Linux/Apache webserver, to connect to an Access database running on a remote NT box? The NT box is a back office server behind a firewall. In a nutshell, the customer wants his website to be able to record on-line sales in his Access-based Point of Sale system. The POS system will be running simultaneously. I haven't done much work with Access, but my impression is that it locks tables and there might be some difficulties sharing write access to the data, but I could be wrong about this. Is there any way Access can be stretched to do this kind of thing? Thanks. -- John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --James HughbanksMikro-Data Engineering Dept. support@mikro-data.net 1-866-457-6287 http://www.mikro-data.net