microsoft.public.sqlserver.xml: Re: Error trying books online openxml example
Re: Error trying books online openxml example
Source: http://www.tech−archive.net/Archive/SQL−Server/microsoft.public.sqlserver.xml/2004−03/0115.html
From: CCA Dave (david_at_notreally.co.uk) Date: 03/16/04
Date: Tue, 16 Mar 2004 13:39:14 −0000
I found a technet article on MSDE which pointed me to the fix. I installed SQL sp3 after xml3.0 which seemed to kill it. Installing xml2.6 fixed if back up . documented in KB823490 Does anyone know of a prerequisites list for XML on SQL? I seem to be running into configuration problems at each step. DC "Dennis Redfield" wrote in message news:ORnQFs1CEHA.1544@TK2MSFTNGP09.phx.gbl... > Dave, > Give us your major and minor versions of SQL Server please. > > thanks. > dlr > > "CCA Dave" wrote in message > news:c36ra4$20u$1$8300dec7@news.demon.co.uk... > > 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. Re: Error trying books online openxml example 1
microsoft.public.sqlserver.xml: Re: Error trying books online openxml example >> > > 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 =' > > > > > > OrderDate="1996−07−04T00:00:00"> > > > > > > > > > > > > OrderDate="1996−08−16T00:00:00"> > > > > > > > > ' > > −−Create an internal representation of the XML document. > > EXEC sp_xml_preparedocument @idoc OUTPUT, @doc > > −− Execute a SELECT statement that uses the OPENXML rowset provider. > > SELECT * > > FROM OPENXML (@idoc, '/ROOT/Customer',1) > > WITH (CustomerID varchar(10), > > ContactName varchar(20)) >> >> >> > >
Re: Error trying books online openxml example
2