Forum Moderators: coopster

Message Too Old, No Replies

ansi nulls error

         

jackvull

4:14 pm on Apr 30, 2008 (gmt 0)

10+ Year Member



I am getting this error in my script.
I compiled the SQL server stored procedure with these settings so not sure what I have to set now:

Warning: mssql_query() [function.mssql-query]: message: 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. (severity 16) in C:\Inetpub\wwwroot\Finance\kpiImport.php on line 136

Warning: mssql_query() [function.mssql-query]: Query failed in C:\Inetpub\wwwroot\Finance\kpiImport.php on line 136
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.

henry0

9:55 pm on Apr 30, 2008 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I don't have an answer, however I think that you should try posting in DB forum.
Most of us here are on a *NIX system