Re: Re: to connect access mdb
| From: | Edwin Boersma | Date: | Sun, 02 Feb 2003 09:48:37 +0000 |
| Subject: | Re: Re: to connect access mdb | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25337@lists.php.net to get a copy of this message | ||
Sorry, I wasn't looking good and sent the post too fast :-( I have these strange reactions on M$ stuff.....
Micah Stevens wrote:
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(); ?>