Zeos(6.1.5) + MsSQL

[klchin]

Hi Alls,

How to solve this option setting,

when execute the SQL below

Select * from
subMsSQLsvr.DatabaseName.dbo.TableName.

where I connected to the main MsSQL server and
wanted access the sub-MsSQL server.

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.

Regards
KL Chin