Prev: Oracle / Random errors
Next: Oracle Intermittent Connection Problem
From: "Phuoc Diec" on 4 Apr 2006 19:54
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
 | 
Pages: 1
Prev: Oracle / Random errors
Next: Oracle Intermittent Connection Problem