microsoft.public.sqlserver.xml: Error trying books online openxml example
Error trying books online openxml example
Source: http://www.tech−archive.net/Archive/SQL−Server/microsoft.public.sqlserver.xml/2004−03/0112.html
From: CCA Dave (david_at_notreally.co.uk) Date: 03/16/04
Date: Tue, 16 Mar 2004 12:18:11 −0000
Can anyone help an aging VMS programmer to get to grips with this? I've created my virtual directory and run an http request "root/sql=select blah etc." and it works fine. Now what I want to do is try to process some XML to update a table by "preparing" an XML document to use as a table (then removing it) I get the error message: Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument, Line 18 Failed to load Msxml2.dll. when I try the example in BOL below. I have installed xml3.0 and have msxml3.dll in %windows%system32, but query analyzer (& SQL?) seem to want to use xml2. Anyone know why? Or am I being a complete noddy? DECLARE @idoc int DECLARE @doc varchar(1000) SET @doc =' ' −−Create an internal representation of the XML document. EXEC sp_xml_preparedocument @idoc OUTPUT, @doc Error trying books online openxml example 1
microsoft.public.sqlserver.xml: Error trying books online openxml example −− Execute a SELECT statement that uses the OPENXML rowset provider. SELECT * FROM OPENXML (@idoc, '/ROOT/Customer',1) WITH (CustomerID varchar(10), ContactName varchar(20))
Error trying books online openxml example
2