RE: [PHP] SQL Server test tool

2002-05-15 Thread Collins, Robert 

This is not tested but should work


$mysql_host = "localhost:1433";
$mysql_login = "billy";
$mysql_pw = "bob";

if(!$db_conn = mysql_connect($mysql_host, $mysql_login, $mysql_pw)){
echo "Connection Failed";
}


Robert W. Collins II 
Webmaster 
New Orleans Regional Transit Authority 
Phone : (504) 248-3826 
Email : [EMAIL PROTECTED] 
 

-Original Message-
From: Scott St. John [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 15, 2002 6:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL Server test tool

Has anyone seen or know if it is possible to use PHP to test if a SQL 
server is alive on port 1433?  I know I could run a query, but was
looking 
for something to actually test on the port.

Thanks,

-Scott


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
 

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

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

RE: [PHP] SQL Server test tool

2002-05-15 Thread Matthew Walker 

Just attempt to connect. If it succeeds, the server is alive.

Matthew Walker
Senior Software Engineer
ePliant Marketing
 

-Original Message-
From: Scott St. John [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, May 15, 2002 6:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL Server test tool

Has anyone seen or know if it is possible to use PHP to test if a SQL 
server is alive on port 1433?  I know I could run a query, but was
looking 
for something to actually test on the port.

Thanks,

-Scott


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



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002
 

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

RE: [PHP] SQL Server test tool

2002-05-15 Thread Jared Boelens 

I would imagine that you could use fsockopen to open a socket connection on
that port in order to test it.

-Jared

-Original Message-
From: Scott St. John [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 8:53 AM
To: [EMAIL PROTECTED]
Subject: [PHP] SQL Server test tool


Has anyone seen or know if it is possible to use PHP to test if a SQL
server is alive on port 1433?  I know I could run a query, but was looking
for something to actually test on the port.

Thanks,

-Scott


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



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

[PHP] SQL Server test tool

2002-05-15 Thread Scott St. John 

Has anyone seen or know if it is possible to use PHP to test if a SQL 
server is alive on port 1433?  I know I could run a query, but was looking 
for something to actually test on the port.

Thanks,

-Scott


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