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=Microsoft.Jet.OLEDB.4.0;'. 'Data
Source=\\\\10.0.0.181\\db\\newres.mdb;';
$rs = NewADOConnection('ado_access'); ----> "unknown command"

Thanks
Bill

[Erwin Moller]

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

[Manuel Lemos]

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/

[Tim Roberts]

"Bill" <dd*@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, ti**@probo.com
Providenza & Boekelheide, Inc.

[J.O. Aho]

Tim Roberts wrote:

"Bill" <dd*@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

[Geoff Muldoon]

us**@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