mssql is driving me crazy

[idgaf]

I've got a PHP script that is driving me insane.

• Windows 2003 Server w/IIS 6
• PHP 4.3.9 in CGI/FastCGI mode
• MS SQL 8.00.760 (SP3)

This code:

define("db_hostname", "XBOX");
define("db_database", "CRM_DEV");

function query() {
	$_conn = mssql_pconnect(db_hostname) or die(mssql_get_last_message());
	mssql_select_db(db_database, $_conn) or	die(mssql_get_last_message());
	$_rset = mssql_query(@func_get_arg(0), $_conn) or die(mssql_get_last_message());
	mssql_close($_conn) or die(mssql_get_last_message());
	return $_rset;
}

When, run, almost randomly, I get the following error for no aparent reason:

Warning: mssql_pconnect(): Unable to connect to server: XBOX in C:\Siteroot\crm\data\main.php on line 7

I can not figure it out and I've tried everything I can think of or find on google or forum sites.

Anyone seen behavior like this before?

[devinemke]

have you tried mssql_connect() instead of mssql_pconnect()

[idgaf]

Yes, both. connect yields a Warning: mssql_fetch_assoc(): 5 is not a valid MS SQL-result resource error whereas pconnect does not.

Originally posted by devinemke
have you tried mssql_connect() instead of mssql_pconnect()

[james-uk]

UNIX > Windows.

[idgaf]

I agree, but MS SQL > MySQL. 🙂

MySQL don't support views, triggers, stored procedures or referential integrity checking.