declare @dbpwd as nvarchar(50)
declare @dbcatalog as nvarchar(50)
declare @dbserver as nvarchar(50)
declare @accid as nvarchar(50)
declare @dbpwdgo as nvarchar(50)
set @dbpwd = '12345679a'
set @dbcatalog = 'UFDATA_999_2014'
set @dbserver = 'U8V13'
set @accid = '1000000001'
set @dbpwdgo = '12345679a'
INSERT INTO MES_Comm_MAINACC (connstr,accid,caddress,cdbpwd,cdatabase)
VALUES ('Provider=SQLOLEDB.1;Password=' + @dbpwd
+ ';Persist Security Info=True;User ID=sa;Initial Catalog=' +
@dbcatalog + ';Data Source=' + @dbserver +
';Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=' +
@dbserver + ';Use Encryption for Data=False;Tag with column collation when possible=False',
@accid,@dbserver,@dbpwd,@dbcatalog)
UPDATE MES_Comm_MAINACC SET CONNSTR= 'Provider=SQLOLEDB.1;Password=' + @dbpwd + ';Persist Security Info=True;User ID=sa;Initial Catalog=' + @dbcatalog + ';Data Source=' + @dbserver + ';Current Language=Simplified Chinese;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID='
+ @dbserver +';Use Encryption for Data=False;Tag with column collation when possible=False', CADDRESS = @dbserver,CDBPWD=@dbpwdgo
GO
找不到存储过程 'Password'。
按照此错误信息应该就是系统缺少‘password’这个存储过程,所以只要给系统添加这个存储过程就可以了,具解决方式如下:
打开“查询分析器”,登录的时候选择“Windows验证”而非默认的“SQL Server身份验证”,在MES_Comm_MAINACC 表右键选择“新建查询”下执行以下语句: