Error message when you use the sp_OACreate stored procedure to create an OLE object from a 32-bit COM DLL in an x64 edition of SQL Server 2005: "0x80040154 ODSOLE Extended Procedure Class not registered"

Symptoms

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

Cause

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.

Workaround

To work around this problem, use a 64-bit compiler to recompile the COM DLL.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Properties

Article ID: 932872 - Last Review: Jun 16, 2008 - Revision: 1

Feedback