Re: Re: to connect access mdb
| From: | Micah Stevens | Date: | Sat, 01 Feb 2003 20:43:57 +0000 |
| Subject: | Re: Re: to connect access mdb | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-25322@lists.php.net to get a copy of this message | ||
looks like PHP to me.
COM connections to Access only handle a few connections at a time. The use of a real DB server is reccommended in your situation.i
Edwin Boersma wrote:
To: php-db@lists.php.net Date: Sat, 01 Feb 2003 18:41:49 +0200 From: Edwin Boersma <edwin@orangeport.net> Subject: [PHP-DB] Re: to connect access mdb 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) {-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php$fv = $rs->Fields("ad"); echo "Value: ".$fv->value."<br>\n"; $rs->MoveNext();} $rs->Close(); ?>