|
Imagine a Windows Server 2003 Enterprise x64 Edition. I can create a 'vbscript.regexp' object using a vbscript (confirming that the DLL is registered). I cannot create a 'vbscript.regexp' object using sp_OACreate in a SQL Server 2005 SP3 (.4053)(cluster) environment. OLE Automation is checked ON in surface area configuration. The sp_OACreate was working until very recently. Can you help me? ****CODE****
(comments are locked)
|
|
Is there any environment change like from 32 bit to 64 bit? Normally, This problem occurs because Microsoft does not support creating an OLE object from a 32-bit COM DLL in an x64 edition of SQL Server 2005. To work around this problem, use a 64-bit compiler to recompile the COM DLL. Please let us know if this solves your problem.
(comments are locked)
|

