Re: to connect access mdb
| From: | Edwin Boersma | Date: | Sat, 01 Feb 2003 16:41:49 +0000 |
| Subject: | Re: to connect access mdb | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25318@lists.php.net to get a copy of this message | ||
Use the correct ng for your problems..... this is for PHP, not ASP.
Qt wrote:
Dear Sirs,
I try to connect my access mdb with following script but I can not succed. I
get following error.
This server is currently overloaded - please try again later
Any idea where is the my mistake. I am using xitami server under windows 98.
<?
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
// Microsoft Access connection string.
$conn->Open("Provider=Microsoft,.Jet.OLEDB.4.0; Data
Source=C:\\Xitami\\webpages\\sigorta.mdb");
// SQL statement to build recordset.
$rs = $conn->Execute("SELECT ad FROM baydar");
echo "<p>Below is a list of values in the MYDB.MDB database, MYABLE table,
MYFIELD field.</p>";
// Display all the values in the records set
while (!$rs->EOF) {
$fv = $rs->Fields("ad");
echo "Value: ".$fv->value."<br>\n";
$rs->MoveNext();
}
$rs->Close();
?>