May 17, 2011 at 5:50 am
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
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