how to use adodb with php/linux?

[Bill]

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=Micro soft.Jet.OLEDB. 4.0;'. 'Data
Source=\\\\10.0 .0.181\\db\\new res.mdb;';
$rs = NewADOConnectio n('ado_access') ; ----> "unknown command"

Thanks
Bill

[Erwin Moller]

Re: how to use adodb with php/linux?

Bill wrote:
[color=blue]
> 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"[/color]

Hi,

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

[color=blue]
> $conn = 'Provider=Micro soft.Jet.OLEDB. 4.0;'. 'Data
> Source=\\\\10.0 .0.181\\db\\new res.mdb;';
> $rs = NewADOConnectio n('ado_access') ; ----> "unknown command"[/color]

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
OpenOfficeCross over or something like that. I think that is overkill.

Good luck,

Regards,
Erwin Moller

[color=blue]
>
> Thanks
> Bill[/color]

[Manuel Lemos]

Re: how to use adodb with php/linux?

Hello,

on 02/27/2006 10:25 AM Bill said the following:[color=blue]
> 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=Micro soft.Jet.OLEDB. 4.0;'. 'Data
> Source=\\\\10.0 .0.181\\db\\new res.mdb;';
> $rs = NewADOConnectio n('ado_access') ; ----> "unknown command"[/color]

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/

[Tim Roberts]

Re: how to use adodb with php/linux?

"Bill" <ddd@ddd.ca> wrote:[color=blue]
>
>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=Micro soft.Jet.OLEDB. 4.0;'. 'Data
>Source=\\\\10. 0.0.181\\db\\ne wres.mdb;';
>$rs = NewADOConnectio n('ado_access') ; ----> "unknown command"[/color]

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.

[J.O. Aho]

Re: how to use adodb with php/linux?

Tim Roberts wrote:[color=blue]
> "Bill" <ddd@ddd.ca> wrote:[color=green]
>> 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=Micro soft.Jet.OLEDB. 4.0;'. 'Data
>> Source=\\\\10.0 .0.181\\db\\new res.mdb;';
>> $rs = NewADOConnectio n('ado_access') ; ----> "unknown command"[/color]
>
> 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.[/color]

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

[Geoff Muldoon]

Re: how to use adodb with php/linux?

user@example.ne t says...
[color=blue][color=green]
> > 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.[/color]
>
> 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:[/color]

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

GM