我需要用ScriptControl中的方法来进行数学表达式的计算,可是在SQL2005中OACreate创建MSScriptControl.ScriptControl时总是失败,而创建其他对象没问题.
DECLARE @error INT,@hScript INT,@ret VARCHAR(200)
EXEC @error=sp_OACreate 'MSScriptControl.ScriptControl',@hScript OUT
select @hScript,@error
EXEC @error=sp_OADestroy @hScript输出错误是-2147221005,应用程序定义或对象错误.
DECLARE @error INT,@hScript INT,@ret VARCHAR(200)
EXEC @error=sp_OACreate 'MSScriptControl.ScriptControl',@hScript OUT
select @hScript,@error
EXEC @error=sp_OADestroy @hScript输出错误是-2147221005,应用程序定义或对象错误.
exec sp_configure 'Ole Automation Procedures',1
go
reconfigure
go
DECLARE @error INT,@hScript INT,@ret VARCHAR(200)
EXEC @error=sp_OACreate 'MSScriptControl.ScriptControl',@hScript OUT
select @hScript,@error
EXEC @error=sp_OADestroy @hScript
测了一下没问题