sp_OACreate and DDLHost.exe  
Author Message
Wowway





PostPosted: Tue May 31 02:49:35 CDT 2005 Top

SQL Server Developer >> sp_OACreate and DDLHost.exe

Hi,

I have a .NET DLL which I need to access in SQL Server.
I followed David Browne's article on how to register the .NET DLL, use
it like a COM object and access it in SQL Server using the extended
stored procedures.

Here's David Browne's article:
http://www.hide-link.com/ ;lr=&selm=u%24dR%233nTEHA.347...

However, I noticed that the CPU usage of theincreases up to 100% and
this is caused by the dllhost.exe and sometimes there are several
instances of the dllhost.exe. Im not sure why this happens..

I hope some one can help. Im kinda stumped with this problem.

Thanks in advance for the help!

Mayet

SQL Server222  
 
 
Gert





PostPosted: Tue May 31 02:49:35 CDT 2005 Top

SQL Server Developer >> sp_OACreate and DDLHost.exe Not the answer to the question but please read
http://support.microsoft.com/default.aspx?scid=kb;en-us;322884, it is not
supported to bring the CLR into the SQL Server process space.



Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2005 All rights reserved.



> Hi,
>
> I have a .NET DLL which I need to access in SQL Server.
> I followed David Browne's article on how to register the .NET DLL, use
> it like a COM object and access it in SQL Server using the extended
> stored procedures.
>
> Here's David Browne's article:
> http://groups.google.com.ph/groups?hl=tl&lr=&selm=u%24dR%233nTEHA.347...
>
> However, I noticed that the CPU usage of theincreases up to 100% and
> this is caused by the dllhost.exe and sometimes there are several
> instances of the dllhost.exe. Im not sure why this happens..
>
> I hope some one can help. Im kinda stumped with this problem.
>
> Thanks in advance for the help!
>
> Mayet
>