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--