SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Failed to load msxmlsql.dll


Failed to load msxmlsql.dll

Author
Message
Manvendra
Manvendra
SSC Veteran
SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)SSC Veteran (238 reputation)

Group: General Forum Members
Points: 238 Visits: 179
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.
Martin CLAVREUIL
Martin CLAVREUIL
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 5
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search