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=’

‘ />

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">quote:<hr height="1" noshade id="quote">Originally posted by john.jonsson I think it was to specicific for Exchange. I didn’t find anything helpful <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /> <hr height="1" noshade id="quote"></blockquote id="quote"> I know the website says err.exe is for exchange, but it’s not. err.exe is basically a compiled database of (almost) every .h file in MS code that defines error codes. the problem is, if you don’t have an idea of what .h file it’s in, you can get a lot of results back. EDIT: PSS is MS Product Support Services. basically customer support. I think they call it CSS now though – C is for Customer. Makes it sound more "customer" focused. [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] <hr noshade size="1">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 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=’

‘ /> http://support.microsoft.com/default.aspx/kb/322884/en-us</a> I fixed it with a .net clr in sql 2005. Sql 2000 is still using oa_create because it’s works. Not supported != Not working <blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by dineshasanka I had the same problem http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=14746</a> Iwas told that OA_Create will be discountined in coming versions —————————————- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com</a> Visit my Blog at http://dineshasanka.spaces.live.com/</a> <hr height="1" noshade id="quote"></blockquote id="quote">

]]>