Hello all,
I'm having a problem getting PHP to run a query against a MSSQL 7 database.
I have installed PHP, the MSSQL client tools and the php_mssql.dll all
according to the documentation.
PHP will connect to the database just fine. But if I send the query to
execute it will never return, no error, no results; the browser will
eventually time out. The query will run from fine from the client tools on
the server. Here is the simple code on trying to get to run:
<?
/*All variables have been set already*/
echo "<h3>Begin</h3>";
$linkID = mssql_connect($hostname,$username,$password) or DIE("DATABASE
FAILED TO RESPOND.");
echo "<h3>Connected</h3>";
mssql_select_db($dbName) or DIE("Table unavailable");
echo "<h3>DB Set</h3>";
flush();
sleep(20); /* Sleep for debug - to allow me to see php loggin in db */
die();
/**** I can get to here - no problems - sp_who inside the MSSQL db
shows I'm connected successfully and am using the DB I've
requested. If I remove the above 'die' or move it to just after
the mssql_query statement below this page will never return.
****/
$query = "SELECT getdate()";
$result = mssql_query($query, $linkID);
echo "<h3>Query Submitted</h3>";
/* code to retrieve and display results goes here */
?>
So can anyone give me some hints? Is there a special place to look for error
messages? The database server doesn't think any error or query has happened
and apparently the Web server is waiting for the database server to reply.
Thanks in advance,
Frank [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
