sp_OACreate + Sql Server 2005 problem!
- From: "Wagner Bertolini Junior" <wagnerbertolini@xxxxxxxxxxxxxxxxxx>
- Date: Mon, 25 Feb 2008 16:38:32 -0300
Hi folks,
I am having some dificulties with the extended procedure sp_OACreate, only
when using the SQL Server 2005.
I am using some COM+ objects inside a procedure, and to access these objects
and create them I was using these extended procedures : sp_OACreate,
sp_OADestroy, and others.
But, on microsoft SQL Server 2005, this generates an error SOMETIMES. This
occurs just one time a week or one time each two days. And the procedure are
used all the time. All day long.
After this error occurs it's impossible to use any COM object. All creates
that I try just return the same error : "A dynamic link library (DLL)
initialization routine failed".
This error is returned by sp_OAGetErrorInfo procedure.
When I reboot the server, the error disappear.
Does anyone knows about this error?
Does anyone imagine how to solve it, or what is causing it?
I'am sorry about my english.
Thanks,
--
Wagner Bertolini Junior
Microsoft Certified Solution Developer
Microsoft Certified Technology Specialist
.
- Follow-Ups:
- Re: sp_OACreate + Sql Server 2005 problem!
- From: Erland Sommarskog
- Re: sp_OACreate + Sql Server 2005 problem!
- Prev by Date: Re: Management Studio Versions
- Next by Date: Cannot install Workstation Components (Management Studio,etc) (ADD_LOCAL error)
- Previous by thread: Re: Management Studio Versions
- Next by thread: Re: sp_OACreate + Sql Server 2005 problem!
- Index(es):
Relevant Pages
|
