Posted by J.O. Aho on 03/01/06 10:22

Tim Roberts wrote:
> "Bill" <ddd@ddd.ca> wrote:
>> I discovered adodb and is use it now in order to connect from PHP to ms
>> Access under Windows. No problem.
>> Is this also applicable to PHP under linux, because i get a lot of errors
>> like:
>> include('../adodb/adodb.inc.php'); ---->"permission denied"
>> $conn = 'Provider=Microsoft.Jet.OLEDB.4.0;'. 'Data
>> Source=\\\\10.0.0.181\\db\\newres.mdb;';
>> $rs = NewADOConnection('ado_access'); ----> "unknown command"
>
> The Microsoft Jet engine, which reads Access database, runs ONLY on
> Windows. ADOdb can read Mysql and Postgres databases (and some others),
> but not Access.
>
> As far as I know, there are no Linux modules that correctly manipulate
> Access databases on Linux.

Best option would be to leave Access behind and migrate to say Mysql, here is
one page describing how and telling the authors opinion why too:

http://www.kitebird.com/articles/access-migrate.html


//Aho

• Next in forum: Re: php form mail problem
• Prev in forum: Re: how to use adodb with php/linux?
• Thread view: Re: how to use adodb with php/linux?

[Reply to this message]