Microsoft KB Archive/932872

= 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: &quot;0x80040154 ODSOLE Extended Procedure Class not registered&quot; =

Article ID: 932872

Article Last Modified on 11/20/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Standard X64 Edition
 * Microsoft SQL Server 2005 Enterprise X64 Edition

-



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 &quot;Applies to&quot; section.

Keywords: kbtshoot kbprb kbexpertiseadvanced KB932872

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.