Re: question in ADODB
| From: | pei_world | Date: | Fri, 21 Feb 2003 11:13:45 +0000 |
| Subject: | Re: question in ADODB | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25824@lists.php.net to get a copy of this message | ||
thank you very much
--
Sincerely your;
pei_world ( .::IT::. )
"Philippe Saladin" <pheuh@yahoo.fr> wrote in message
news:20030221091247.50498.qmail@pb1.pair.com...
> > 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
>
>