Post reply

Failed to load msxmlsql.dll

  • May 17, 2011 at 5:50 am

    #99673

    Hi

    Whenever i am running any DML cmds on sql server Instance.i am getting this error.i tried a lot much things.

    replace this dll with the same version of dll from other servers where it was runing fine.

    reinstall msxml.msi.

    We have 2 intsnace on this box sql 2005 and 2008.2005 instance is working fine but we r getting this error on 2008 instance.

    Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line 1

    Failed to load Msxmlsql.dll.

    Msg 8179, Level 16, State 5, Procedure sp_BankEdit, Line 46

    Could not find prepared statement with handle 0.

  • June 16, 2011 at 10:28 am

    #1339890

    I had a similar problem but with an x64 SQL Server 2008 R2 Developer edition.

    I post the workaround here for those who may be in the same situation.

    Some other product installed an x64 SQL Server 2008 Express beside my 2008R2Dev instance and all xml procedure stop to work with the same message quoted upper.

    The workaround. I copied two files from the installation DVD to my disk.

    Stop the SQL instance

    From the DVD : \1033_ENU_LP\x64\Setup\sql_engine_core_shared_loc_msi\PFiles\SqlServr\100\Shared\Res\1033\msxmlsql.rll

    To : \Program Files\Microsoft SQL Server\100\Shared\Resources\1033

    From the DVD: \x64\Setup\sql_engine_core_shared_msi\PFiles\SqlServr\100\Shared\msxmlsql.ddl

    To : \Program Files\Microsoft SQL Server\100\Shared

    Start the instance.

    Test with a statement like this one:

    DECLARE @docHandle INT

    DECLARE @error INT

    EXEC sp_xml_preparedocument @docHandle OUTPUT, N'<root><child/></root>'

    SET @error =@@ERROR

    IF @error =0

    BEGIN

    EXEC sp_xml_removedocument @docHandle

    END

    And... OK : Command(s) completed successfully.

    Hope it will help

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply