I am attempting to run a query that linked to a different server through my MSSQL server. The query returns an error:
Warning: 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\OCN_Data.php on line 18
I don't know how to set these parameters on server or through the code. Do anyone have any ideas on how to resolve this issue?