You are here: adodb and M$ access databases « All PHP « IT news, forums, messages
adodb and M$ access databases

Posted by Gerald Aichholzer on 09/29/05 21:45

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация