Bug #15325: mssql_query returns early

From: Date: Fri, 01 Feb 2002 16:05:07 +0000
Subject: Bug #15325: mssql_query returns early
Groups: php.dev 
Request: Send a blank email to php-dev+get-78777@lists.php.net to get a copy of this message
From: mike@dct-mail.com Operating system: Windows 2000 Server PHP version: 4.1.1 PHP Bug Type: MSSQL related Bug description: mssql_query returns early Running the 4.1.1 binaries from php.net: Using mssql_query() to issue a backup statement doesn't work $conn = msssql_connect("localhost", "sa", "") or die("bad"); $sql = "BACKUP DATABASE Northwind TO DC_Northwind"; $result = mssql_query($sql, $conn); mssql_close($conn); sets $result to 1 and the script prints: MS SQL message: Cannot create worker thread. (severity 16) in Unknown on Line 0 MS SQL message: BACKUP DATABASE is terminating abnormally. (severity 16) in Unknown on Line 0 Then a dialog box reports: The instruction at "0x100a0f9d" referenced memory at "0x00000000". The memory cannot be "written". SQL Profiler confirms that the backup failed. If a sleep(25) is placed after the call to mssql_query(): 1) The warning messages aren't displayed 2) The backup actually succeeds but 3) The dialog box still appears (and the script terminates). Using the 4.0.6 binaries from the web site the backup behaves identically, BUT the dialog box does not appear and the script terminates cleanly. The SQL Server has all service packs installed and the backup commands work without problem from the query analyzer or isql.exe -- Edit bug report at: http://bugs.php.net/?id=15325&edit=1

« previous php.dev (#78777) next »