Error ANSI_NULLS and ANSI_WARNINGS when calling MSSQL stored procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux