Re: sp_OACreate + Sql Server 2005 problem!

I tried to install this fix, but I couldn't reboot the server yet.

Just the service.

But the problem persists, I will try to reboot the server today.


"BigSam" <BigSam@xxxxxxxxxxxxxxxxxxxxxxxxx> escreveu na mensagem
news:21B5735D-6CD6-4915-A327-E781E4D85A5B@xxxxxxxxxxxxxxxx
I had same problem. I resolved it by installing a hotfix from Microsoft.
See
if this helps: http://support.microsoft.com/kb/937277

"Wagner Bertolini Junior" wrote:

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

  • Another disaster recovery exercise (but not yet)...
    ... I updated a client's Server. ... indeed, I reboot before updating, and after ). ... Chkdsk is all good on all drives. ... Enabling boot logging option at boot - well, ...
    (microsoft.public.backoffice.smallbiz2000)
  • RE: Event 19011: SBS Monitoring services wont auto-start
    ... automatically start when rebooting the SBS server. ... Let us ensure the MSSQL$SBSMONITORING service and the Microsoft Exchange ... Please clean the Event logs in event viewer and then reboot the server, ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • Re: Another disaster recovery exercise (but not yet)...
    ... Do the full system state restore. ... I updated a client's Server. ... > indeed, I reboot before updating, and after ). ... Still very slow boot time and many ...
    (microsoft.public.backoffice.smallbiz2000)
  • Re: IIS Messed UP... must reboot?
    ... SBS and after reboot, the IIS works again. ... Can you see in IIS the websites or server shows stop status? ... Click Services tab and select Hide All Microsoft Services and Disable ... After reboot, check whether the problem still occurs. ...
    (microsoft.public.windows.server.sbs)
  • Re: MS Critical Patches - Reboot - Did not reboot.
    ... Generally the 7036 event pops up after a reboot, ... the install of critical patches. ... down and it comes up using PING SERVER -t. ... I tried connecting through RDP and could not connect. ...
    (microsoft.public.windows.server.general)
Loading