Problem with mssql_query()
| From: | Chris Boget | Date: | Wed, 09 May 2007 13:57:13 +0000 |
| Subject: | Problem with mssql_query() | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-254643@lists.php.net to get a copy of this message | ||
I noticed the following in my logs:
22:04:42 [warning] [D:\PHP\pear\DB\mssql.php][439]: mssql_query(): Unable to set query
22:04:42 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][439]; function( mssql_query ); args( 1[value:select @@ERROR as ErrorCode] 2[value:Resource id #21] )
22:04:42 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][489]; function( errornative )
22:04:42 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][145]; function( mssqlraiseerror )
22:04:42 [info] Backtrace: [D:\PHP\pear\DB\common.php][1146]; function( simplequery ); args( 1[value:SELECT * FROM wording WHERE wording_id = '8' ] )
22:04:42 [critical] Error in the following query:<br><br>SELECT * FROM wording WHERE wording_id = '8' <br>DB Error: unknown error
22:04:52 [warning] [D:\PHP\pear\DB\mssql.php][439]: mssql_query(): Unable to set query
22:04:52 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][439]; function( mssql_query ); args( 1[value:select @@ERROR as ErrorCode] 2[value:Resource id #21] )
22:04:52 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][489]; function( errornative )
22:04:52 [info] Backtrace: [D:\PHP\pear\DB\mssql.php][145]; function( mssqlraiseerror )
22:04:52 [info] Backtrace: [D:\PHP\pear\DB\common.php][1146]; function( simplequery ); args( 1[value:SELECT * FROM wording WHERE wording_id = '8' ] )
22:04:52 [critical] Error in the following query:<br><br>SELECT * FROM wording WHERE wording_id = '8' <br>DB Error: unknown error
Why is mssql_query() saying that it's unable to set the query? I did some searching on Google and found that people were having this problem but that was back in 2001 using an earlier version of PHP. We are using version 4.3.11 and Microsoft SQL Server 2000 - 8.00.2039 (Intel X86).
Has anyone had a similar problem? What was your solution? Why is this happening?
thnx,
Chris