how to use adodb with php/linux?

Hi,

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"

Thanks
Bill

Bill wrote:

> Hi,
>
> 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"

Hi,

That means that PHP cannot read the file.
Check the filepermissions so PHP can read it (and the subdirectories).


> $conn = 'Provider=Microsoft.Jet.OLEDB.4.0;'. 'Data
> Source=\\\\10.0.0.181\\db\\newres.mdb;';
> $rs = NewADOConnection('ado_access'); ----> "unknown command"

Read the Fine Manual:

http://www.phplens.com/adodb/supported.databases.html

Read the first lines in the table: access is not supported under *nix by
ADODB.

You'll have to find another solution:
1) Pick a database that runs under *nix, like Postgresql or mysql.
2) Try to connect to Access on a W$ machine from PHP on *nix using ODBC.
(So you need 2 machines)
3) Try to find some lib that support access on *nix directly, but I don't
know of any.
4) Maybe it is possible with windowboxes/emulations on *nix, like WINE or
OpenOfficeCrossover or something like that. I think that is overkill.

Good luck,

Regards,
Erwin Moller


>
> Thanks
> Bill

Hello,

on 02/27/2006 10:25 AM Bill said the following:
> Hi,
>
> 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"

I don't know with ADODB because I do not use it, but you can use
Metabase which is another database abstraction package that has a MS
Access driver that can be used to access your database in Linux or Windows:

http://www.phpclasses.org/metabase

--

Regards,
Manuel Lemos

Metastorage - Data object relational mapping layer generator
http://www.metastorage.net/

PHP Classes - Free ready to use OOP components written in PHP
http://www.phpclasses.org/

"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.
--
- Tim Roberts, timr@probo.com
Providenza & Boekelheide, Inc.

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

user@example.net says...

> > 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:

Or the new free Oracle XE may now also be worth a look.

GM