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"

Article translations Article translations
Article ID: 932872 - View products that this article applies to.
Expand all | Collapse all

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: November 20, 2007 - Revision: 1.2
APPLIES TO
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Enterprise X64 Edition
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB932872

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com