none
"A dynamic link library (DLL) initialization routine failed" Error

    Question

  • This error is occuring on Windows 2003 SP2 64 bit running SQL Server 2008 R2.  I'm using OLE Automation stored procedures to send emails via CDO.  Here is the method I'm using to send the emails.

    http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech

    Here is more information from the error.

     

    Source of Failure Description of Failure Output from Failure Comment about Failure
    NULL NULL NULL Failed at sp_OASetProperty sendusing
    CDO.Configuration.1 A dynamic link library (DLL) initialization routine failed.     Description: A dynamic link library (DLL) initialization routine failed.   sp_OAGetErrorInfo for sp_OASetProperty sendusing

    After searching around I'm pretty certain the error is due to a Windows problem and not SQL Server.

    Here is a Windows hotfix that seems to apply however I'm not sure.

    http://support.microsoft.com/kb/941105/en-us

    The few forum thread's I've found say restarting the server will temporarily solve the problem.  Could someone tell me if the hotfix will correct this?

     


    Kevin
    Tuesday, May 17, 2011 6:45 PM

All replies

  • One other thing.  The support article 941105 lists these file versions.

    File name File version
    Hal.dll 5.2.3790.4225
    Ntkrnlmp.exe 5.2.3790.4225
    Ntoskrnl.exe 5.2.3790.4225

    However, these are the versions on my server.

    File name File version
    Hal.dll 5.2.3790.3959
    Ntkrnlmp.exe 5.2.3790.4666 
    Ntoskrnl.exe 5.2.3790.4666 

    I'm not sure I should install the hotfix since two out of the three that are installed are later versions than mention in the hotfix.

     


    Kevin
    Tuesday, May 17, 2011 6:51 PM