Zeos(6.1.5) + MsSQL
Posted: 02.09.2005, 06:32
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
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