Re: question in ADODB
| From: | Philippe Saladin | Date: | Fri, 21 Feb 2003 09:12:19 +0000 |
| Subject: | Re: question in ADODB | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25815@lists.php.net to get a copy of this message | ||
> 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 :
include("adodb.inc.php");
$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