Hi everybody
i have added a linked server (Linkser)having sybase db in mssql server.i
added a
procedure for getting data from Linkser
SET ANSI_NULLS ON
GO
SET ANSI_WARNINGS ON
GO
CREATE procedure prom_per
as begin
SELECT * FROM Linkser..dba.pr_per
end
this working fine in sqlanalyser.when i try from my powerbuilder applcn its
showing the msg(Heterogeneos queries required the ANSI_NULLS,ANSI_WARNINGS
options to be set for the connection,enable this and try again.how can i
solve this please help.