sql server - OLE Error in SQL -
i have windows server 2003 standard x64 edition sp2
microsoft sql server 2005 - 9.00.4035.00 (x64) enterprise edition (64-bit) on windows nt 5.2 (build 3790: service pack 2)
i downloaded capicom platform sdk redistributable: http://www.microsoft.com/downloads/details.aspx?familyid=860ee43a-a843-462f-abb5-ff88ea5896f6&displaylang=en
and installed c:\windows\syswow64 c:\windows\syswow64\regsvr32.exe capicom.dll , got registered succesfully.
when tried run
declare @s varchar(255) declare @d varchar(255) declare @o int exec @c = sp_oacreate 'capicom.encrypteddata', @o out if @c <> 0 begin exec sp_oageterrorinfo @o, @s out, @d out select err=convert(varbinary(4),@c), source=@s, description=@d return end
and got error message.
0x80040154 odsole extended procedure class not registered
what should do? how should check if capicom.dll correctly registered?
this answer has walkthrough of how register surrogate capicom can used 64-bit processes.
i have done use capicom 64-bit sql server , works fine.
Comments
Post a Comment