# [PHP-DB] Re: question in ADODB

> yes, but can you tell me how? I have read the manual, but they didn't tell
> how to do so!
>

Look at testdatabases.inc.php in the adodb release.
Basically, you would have to write something like :

$conn = NewADOConnection('ado_access');$conn->debug = TRUE; // useful for test
$access = '\path\to\mydatabase.mdb';$myDSN =  "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=$access;USER ID=;PASSWORD=;";$conn->PConnect($myDSN, '', '', '');$recordSet = $conn->Execute('select * from products'); if (!$recordSet) { echo  \$conn->ErrorMsg();}

Regards,
Philippe

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php