Error ANSI_NULLS and ANSI_WARNINGS when calling MSSQL stored procedure

Error ANSI_NULLS and ANSI_WARNINGS when calling MSSQL stored procedure

am 05.04.2006 01:54:13 von Phuoc Diec

------=_Part_2098_24419148.1144194853039
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

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

------=_Part_2098_24419148.1144194853039--