--应用程序通过链接服务器更新本地数据出错!
通过一个存储过程处理数据,存储过程中有通过链接服务器,
从其它服务器的数据库中,读取资料并更新本地数据库,
在查询分析器中可以成功处理,但通过应用程序调用出错,出错信息如下: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.查了帮助,帮助中说需将 ANSI_NULLS/ANSI_WARNINGS 设为 on但我按下面的写法处理了,还是报错,请各位帮忙看看!
drop proc p_1
go
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON ---此处加上SET ANSI_NULLS ON 是否正确
GO
SET ANSI_WARNINGS ON---此处加上SET ANSI_WARNINGS ON 是否正确
GOcreate procedure p_1
as
set nocount on
begin
if .....
--程序处理
endSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOGRANT EXECUTE ON [dbo].[p_1] TO [public]
GO
通过一个存储过程处理数据,存储过程中有通过链接服务器,
从其它服务器的数据库中,读取资料并更新本地数据库,
在查询分析器中可以成功处理,但通过应用程序调用出错,出错信息如下: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.查了帮助,帮助中说需将 ANSI_NULLS/ANSI_WARNINGS 设为 on但我按下面的写法处理了,还是报错,请各位帮忙看看!
drop proc p_1
go
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON ---此处加上SET ANSI_NULLS ON 是否正确
GO
SET ANSI_WARNINGS ON---此处加上SET ANSI_WARNINGS ON 是否正确
GOcreate procedure p_1
as
set nocount on
begin
if .....
--程序处理
endSET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GOGRANT EXECUTE ON [dbo].[p_1] TO [public]
GO
http://community.csdn.net/Expert/FAQ/FAQ_Index.asp?id=3484