Error ANSI_NULLS and ANSI_WARNINGS when calling MSSQL stored procedure
| From: | Phuoc Diec | Date: | Tue, 04 Apr 2006 23:54:13 +0000 |
| Subject: | Error ANSI_NULLS and ANSI_WARNINGS when calling MSSQL stored procedure | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-41657@lists.php.net to get a copy of this message | ||
Hello,
I got the following error message when calling a stored procedure on MSSQL
2000 server:
"Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to
be set for the connection. This ensures consistent query semantics. Enable
these options and then reissue your query. [20018] (severity 5)".
How can I set ANSI_NULLS and ANSI_WARNINGS on when open connections to the
MSSQL 2000 server. I use both mssql_connect and PDO.
Thank you.
Phuoc Diec