sp_OACreate + Sql Server 2005 problem!

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


.

Relevant Pages

  • sp_OACreate + Sql Server 2005 problem!
    ... I am having some dificulties with the extended procedure sp_OACreate, ... But, on microsoft SQL Server 2005, this generates an error SOMETIMES. ... I'am sorry about my english. ...
    (microsoft.public.sqlserver.tools)
  • Re: Problem with extended procedure
    ... Run the query below to verify the login is a sysadmin role member. ... SQL Server MVP ... > i have MS SQL Server 2000 Standard with my own extended procedure. ...
    (microsoft.public.sqlserver.server)
  • Re:can a sysadmin change the win2000 domain admin password ?
    ... to change password using the extended procedure ... does the SQL server with default installation have the ... can he add a user who can possess administrator rights? ...
    (microsoft.public.sqlserver.security)
  • Problem with extended procedure
    ... i have MS SQL Server 2000 Standard with my own extended procedure. ... the safe said)I drop the user and the login and create new login and user. ...
    (microsoft.public.sqlserver.server)
  • invalid value specified for STOPAT parameter
    ... I too had problems when trying to perform a Point in Time restore ... Enterprise Manager, I receive a error message "Invalid value specified ... "YDM" by SQL Server where as the value supplied by the SQL Server ... Select "British English", then hit OK. ...
    (microsoft.public.sqlserver.server)