adodb and M$ access databases
Available news archives: comp.lang.tcl - comp.lang.python - comp.security.firewalls - sci.crypt - comp.lang.php - comp.lang.javascript
Google
 
Web news.hping.org


comp.lang.php archive

adodb and M$ access databases

From: Gerald Aichholzer <gary@sbox.tugraz.at>
Date: Thu Sep 29 2005 - 20:45:44 CEST

Hi all,

I am using the Prade framework which includes a slightly
modified version von adodb 4.61 and I am working with M$
Access databases via OleDb (TAdodb is a wrapper class of
the ADODB ADOConnection class):

   $source = "Provider=Microsoft.Jet.OLEDB.4.0;".
             "Data Source=d:\temp\test.mdb";

   $this->connection = new TAdodb();
   $this->connection = &ADONewConnection('ado_access');
   $this->connection->setFetchMode('Associative');
   $this->connection->Connect($source);

Although I have activated associative fetchmode I only
get field indices in my query results. Using SQLite as
database (which is unfortunately not an option for my
current project) it works as expected.

I have already searched Google, the phplens-forum and the
adodb mailing list, but haven't found anything useful.

Is this a known bug/feature of adodb?
Is there a solution for getting field names in the query
results?

any help is appreciated - thanx in advance,
Gerald

PS: I am working with PHP 5.03 under Windows 2000

PPS: xpost to alt.php and f'up to comp.lang.php
Received on Tue Oct 18 02:29:39 2005