Re: [PHP-DB] Re: to connect access mdb

2003-02-02 Thread Edwin Boersma
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: [EMAIL PROTECTED]
Date: Sat, 01 Feb 2003 18:41:49 +0200
From: Edwin Boersma [EMAIL PROTECTED]
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 pBelow 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();
?




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[PHP-DB] Re: to connect access mdb

2003-02-01 Thread Edwin Boersma
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 pBelow 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();
?





--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




Re: [PHP-DB] Re: to connect access mdb

2003-02-01 Thread Micah Stevens

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: [EMAIL PROTECTED]
Date: Sat, 01 Feb 2003 18:41:49 +0200
From: Edwin Boersma [EMAIL PROTECTED]
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 pBelow 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();
?




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php