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?
asked Nov 20 '11 at 01:56 PM in Default
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.
answered Nov 20 '11 at 09:03 PM