Re: [PHP] Accessing .mdb Ms Access file from Linux without ODBC

2006-09-07 Thread Angelo Zanetti
Fourat Zouari wrote: Hello all, I need to create a script that can open a connection to a given .mdb file (Microsoft Access) and do some light selects on it, anyway ... The problem that i wont create an ODBC instance, i wont and cant install ODBC support on the server for the unique purpose

Re: [PHP] Accessing .mdb Ms Access file from Linux without ODBC

2006-09-07 Thread Rory Browne
what does this have to do with PHP? I would assume that he's trying to do it on Linux through PHP. http://mdbtools.sourceforge.net/ http://pecl.php.net/package/mdbtools

Re: [PHP] Accessing .mdb Ms Access file from Linux without ODBC

2006-09-07 Thread Fourat Zouari
it's a PHP question : how can we access Ms Access mdb files without ODBC ? On 9/7/06, Angelo Zanetti [EMAIL PROTECTED] wrote: Fourat Zouari wrote: Hello all, I need to create a script that can open a connection to a given .mdb file (Microsoft Access) and do some light selects on it,

Re: [PHP] Accessing .mdb Ms Access file from Linux without ODBC

2006-09-07 Thread Angelo Zanetti
Fourat Zouari wrote: it's a PHP question : how can we access Ms Access mdb files without ODBC ? On 9/7/06, *Angelo Zanetti* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Fourat Zouari wrote: Hello all, I need to create a script that can open a connection to a given

Re: [PHP] Accessing .mdb Ms Access file from Linux without ODBC

2006-09-07 Thread Joe Wollard
I think kOffice can read mdb files on Linux - maybe that would be a good starting point for research. Perhaps they have built a kind of API to allow other programs to do the same..then again, maybe not - but like I said, it's some place to start. On Sep 7, 2006, at 7:57 AM, Fourat

Re: [PHP] Accessing .mdb Ms Access file from Linux without ODBC

2006-09-07 Thread Fourat Zouari
i want to understand something : when using a dsn like this with adodb : DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/var/tmp/etiq.db should i have an ODBC layer or not ? On 9/7/06, Joe Wollard [EMAIL PROTECTED] wrote: I think kOffice can read mdb files on Linux - maybe that would be a

Re: [PHP] Accessing .mdb Ms Access file from Linux without ODBC

2006-09-07 Thread Fourat Zouari
trying this code : --- BEGIN ?php require_once('/var/www/classes/adodb/adodb.inc.php'); $db = '/var/tmp/db1.mdb'; $dsn = DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db; //$dsn = Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db; $sourceDB =