Rauldinho Posted March 19, 2007 Share Posted March 19, 2007 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.