PHP connection to remote Access database on NT
| From: | John Almberg | Date: | Thu, 11 Sep 2003 01:55:53 +0000 |
| Subject: | PHP connection to remote Access database on NT | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-30457@lists.php.net to get a copy of this message | ||
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