SQL Server Performance Forum – Threads Archive
sp_OACreate returns -2146232576
Hi!Have some problems to create an instance of ‘SqlMsmq.SqlMsmq’ with sp_OACreate (it returns -2146232576) in SQL 2005. SqlMsmq is a dll that I have made in .net 1.1. In sql 2000 this dll works fine but not in 2005. I have tried to upgrade sqlmsmq.dll to .net 2 but with the same result. The dll is registered; If I remove the assembly registration the sp_OACreate returns ODSOLE Extended Procedure: Invalid class string Seehttp://support.microsoft.com/kb/555070/en-us for explanation of what sqlmsmq.dll is. When the sp_OACreate return code != 0 the sp_OAGetErrorInfo is called for an error description. It returns “ODSOLE Extended Procedure†as source, but NULL as Description. Some tips?
Thanks!!
Regards, John
not sure if this will help, but I find err.exe very useful for looking up error codes: http://www.microsoft.com/downloads/…99-7BB8-4208-B7FC-09E02A13696C&displaylang=en SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
www.elsasoft.org
I think it was to specicific for Exchange. I didn’t find anything helpful <img src=’/community/emoticons/emotion-6.gif’ alt=’
![Frown :( :(](styles/default/xenforo/smilies/frown.png)
I suggest to raise a case with PSS as it seems problem with SP_OA execution. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
Don’t know what PSS is but this article wasn’t glad info for me:
http://support.microsoft.com/default.aspx/kb/322884/en-us
Maybe I have to completly change approach.
quote:Originally posted by satya
I suggest to raise a case with PSS as it seems problem with SP_OA execution.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by john.jonsson</i><br /><br />I think it was to specicific for Exchange. I didn’t find anything helpful <img src=’/community/emoticons/emotion-6.gif’ alt=’
![Frown :( :(](styles/default/xenforo/smilies/frown.png)
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
I had the same problem
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=14746 Iwas told that OA_Create will be discountined in coming versions —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/
I read your question before I posted mine. Yes, there is no oacreate support for .net clr’s in sql2000 and 2005 <img src=’/community/emoticons/emotion-6.gif’ alt=’
![Frown :( :(](styles/default/xenforo/smilies/frown.png)
]]>