RE: [PHP] URGENT: Can PHP on Linux deal with Access DB?
| From: | Andrew Hill | Date: | Mon, 05 Nov 2001 14:18:11 +0000 |
| Subject: | RE: [PHP] URGENT: Can PHP on Linux deal with Access DB? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-73485@lists.php.net to get a copy of this message | ||
No. You need Win32 to run MSAccess.
ODBC can be used if you want to connect from your linux box to the Win32
box, but there is no way to run MSAccess (and intrepret the .mdb files)
directly on linux.
If you don't have a Win32 box, then your best bet may be to export the
Access tables into MySQL.
There are some utilities for doing this here
http://www.mysql.com/downloads/contrib.html#SEC649
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Universal Data Access & Data Integration Technology Providers
> -----Original Message-----
> From: Martin Towell [mailto:martin.towell@world.net]
> Sent: Sunday, November 04, 2001 8:51 PM
> To: php-general@lists.php.net
> Subject: RE: [PHP] URGENT: Can PHP on Linux deal with Access DB?
>
>
> I'm interested in knowing how to do this too. If it's at all possible.
>
> Martin
>
> -----Original Message-----
> From: Marco Fioretti [mailto:m.fioretti@inwind.it]
> Sent: Monday, November 05, 2001 9:36 AM
> To: php-general@lists.php.net
> Subject: [PHP] URGENT: Can PHP on Linux deal with Access DB?
>
>
> Hello,
>
> I have been asked to maintain a PHP site hosted on NT/IIS, and have
> only an Apache/RH linux box to do test and development for it.
>
> So far it would be a no-brainer, being PHP as portable as is.
>
> The problem is that on the real server PHP should read and write an
> Access database via ODBC, and, for reasons not worth discussing
> here, I have
> no
> possibility to change this in the foreseable future.
>
> On the other hand, I really don't want to put online untested pages,
> cannot afford buying another NT/IIS box just for this purpose, and
> even less dual booting all the time, because of other Linux only
> projects I can't stop.
>
> The question, then, is if I can copy the Access database files on my
> Linux box and access them via PHP/ODBC/Apache on my PC to test
> completely my
> pages before upload: is this possible? How?
>
> Any other solution (like converting the access DB to Mysql or
> something, in such a way that if the PHP code works on MySQL on my box it
> will also
> work for sure on Access on the IIS server) is extremely welcome!!
>
> Thanks a lot in advance,
>
>