Posted by Erwin Moller on 02/27/06 16:09

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

[Back to original message]