1。 sql1链接接数据库sql2,
2。 用sa登陆sql2
3。 创建存储过程
set ansi_nulls on
set ansi_warnings on CREATE PROCEDURE [dbo].[GetCwMaxMinYear]
AS
begin
Select Min(Convert(int,substring(name,12,4))) as minyear,
Max(Convert(int,substring(name,12,4))) as maxyear
From [sql2].master.dbo.sysdatabases Where substring(name,1,10)='UFDATA_005'
end
GO
set ansi_nulls off
set ansi_warnings off
存储过程在查询分析其中正确执行
delphi用bde方式storedproc控件访问这个储存过程,出现
"Heterogenous queries require the ansi_nulls and ansi_warnings for the connection..."
但用ado方式和adostoredproc就能正确访问
请问有谁碰到这样的问题?
2。 用sa登陆sql2
3。 创建存储过程
set ansi_nulls on
set ansi_warnings on CREATE PROCEDURE [dbo].[GetCwMaxMinYear]
AS
begin
Select Min(Convert(int,substring(name,12,4))) as minyear,
Max(Convert(int,substring(name,12,4))) as maxyear
From [sql2].master.dbo.sysdatabases Where substring(name,1,10)='UFDATA_005'
end
GO
set ansi_nulls off
set ansi_warnings off
存储过程在查询分析其中正确执行
delphi用bde方式storedproc控件访问这个储存过程,出现
"Heterogenous queries require the ansi_nulls and ansi_warnings for the connection..."
但用ado方式和adostoredproc就能正确访问
请问有谁碰到这样的问题?
set ansi_warnings off CREATE PROCEDURE [dbo].[GetCwMaxMinYear]
AS
begin
Select Min(Convert(int,substring(name,12,4))) as minyear,
Max(Convert(int,substring(name,12,4))) as maxyear
From [sql2].master.dbo.sysdatabases Where substring(name,1,10)='UFDATA_005'
end
GO
set ansi_nulls off
set ansi_warnings off
链接数据库时必须设置:
set ansi_nulls on
set ansi_warnings on
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE [dbo].[GetCwMaxMinYear]
AS
begin Select Min(Convert(int,substring(name,12,4))) as minyear,
Max(Convert(int,substring(name,12,4))) as maxyear
From [ky].master.dbo.sysdatabases Where substring(name,1,10)='UFDATA_005'
endGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
///建了一个odbc后,用BDE的控件连接,执行存储过程没有问题.
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE [dbo].[GetDBNames]
AS
begin
Select name From [ky].master.dbo.sysdatabases
endGO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
在ado连接方式是可以的,但在bde下是报错的
“Heterogenous queries require the ansi_nulls and ansi_warnings for the connection..."
2:重建你的ODBC连接,新建工程单独调用看看!
我是这样的,你那边可以吗?ado方式连结用adostoredproc是可以得,但bde的stroedproc就有错
我的存储过程,就是上面我发的那个.
sp_dboption 'sql1','ANSI warnings','on'
go
sp_dboption 'sql1','ANSI nulls','on'
go
sp_dboption 'sql2','ANSI warnings','on'
go
sp_dboption 'sql2','ANSI nulls','on'
go
只是在创建储存过程的时候
set ansi_nulls on 和
set ansi_warnigs on 还不行