In an x64 edition of Microsoft SQL Server 2005, you use the sp_OACreate stored procedure to create an OLE object from a 32-bit Microsoft Component Object Model (COM) DLL. When you do this, you receive the following error message:
0x80040154 ODSOLE Extended Procedure Class not registered
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.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 932872 - Last Review: Jun 16, 2008 - Revision: 1