Jump to content

ANSI_NULLS and ANSI_WARNINGS


Rauldinho

Recommended Posts

Hi, i created a VIEW in mssql and i'm trying to show the data through a PHP page. but when i see the page it gives me this error:

 

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.

 

Searching for help i read that i must set those two to ON. But where can i do this? in the PHP file or in the CREATE VIEW statement??

 

CREATE VIEW myview

AS

SELECT * FROM table;

 

Thanks for any help!!

Link to comment
https://forums.phpfreaks.com/topic/43371-ansi_nulls-and-ansi_warnings/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.