Re: Failed to load msxmlsql.dll

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I run the SQL script on a Virtual PC that's already installed with Microsoft
CRM 3.0 and SQL Server 2000 SP 4. I got the VPC image from Microsoft.

I find the file msxmlsql.dll exists in C:\Program Files\Microsoft SQL
Server\80\Shared directory with file version 1.0.1045.0.

Thanks.



Best regards,



Ronen



"Michael Rys [MSFT]" <mrys@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:uYhiD3QAGHA.532@xxxxxxxxxxxxxxxxxxxxxxx
> Hi Ronen, is this still a problem?
>
> Thanks
> Michael
>
> "Galex Yen [MSFT]" <galexy@xxxxxxxxxxxxxxxxxxxx> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@xxxxxxxxxxxxxxxx
>> Ronen,
>>
>> I have a couple of questions.
>>
>> 1) When you performed the upgrade from SP3, did you get any errors?
>> 2) Does the file msxmlsql.dll exist in the X:\Program Files\Microsoft SQL
>> Server\80\Shared directory (replace X with whatever drive you installed
>> Sql
>> Server on)?
>>
>> Regards,
>> Galex
>>
>> "Ronen" wrote:
>>
>>> Hi All,
>>>
>>> I get the following error message when trying to run the following SQL
>>> script in SQL Server 2000 SP 4.
>>>
>>> SQL Script:
>>> -------
>>> DECLARE @hdoc int
>>> DECLARE @doc varchar(1000)
>>> SET @doc ='
>>> <ROOT>
>>> <Customer CustomerID="VINET" ContactName="Paul Henriot">
>>> <Order CustomerID="VINET" EmployeeID="5"
>>> OrderDate="1996-07-04T00:00:00">
>>> <OrderDetail OrderID="10248" ProductID="11" Quantity="12"/>
>>> <OrderDetail OrderID="10248" ProductID="42" Quantity="10"/>
>>> </Order>
>>> </Customer>
>>> <Customer CustomerID="LILAS" ContactName="Carlos Gonzlez">
>>> <Order CustomerID="LILAS" EmployeeID="3"
>>> OrderDate="1996-08-16T00:00:00">
>>> <OrderDetail OrderID="10283" ProductID="72" Quantity="3"/>
>>> </Order>
>>> </Customer>
>>> </ROOT>'
>>> --Create an internal representation of the XML document.
>>> EXEC sp_xml_preparedocument @hdoc OUTPUT, @doc
>>> -- Remove the internal representation.
>>> exec sp_xml_removedocument @hdoc
>>>
>>> Error Message:
>>> ---------------
>>> Server: Msg 6610, Level 16, State 1, Procedure sp_xml_preparedocument,
>>> Line
>>> 18
>>> Failed to load msxmlsql.dll.
>>>
>>> Does anybody know this error message?
>>>
>>> Thanks,
>>>
>>> Ronen
>>>
>>>
>>>
>
>


.



Relevant Pages

  • Re: searching on more than one field in VB
    ... However, to simulate an SQL ... >> Regards, ... >> Tom Ogilvy ... >>> sheet into one of seven textboxes and search for information in ...
    (microsoft.public.excel.programming)
  • Re: GROUP BY...
    ... > Dominique Javet wrote: ... >> Regards, Dom ... > These two are completely unrelated SQL commands. ... > query, which you didn't. ...
    (comp.lang.php)
  • Re: Multilingual versions of SQL Express 2005 available ? Where ?
    ... So we haven't any further better means without the localized SQL express ... Microsoft Online Support ... | Regards, Keith ... |> we may consider provide localized error message according to the error ...
    (microsoft.public.sqlserver.setup)
  • Re: My own security subsystem
    ... will look in the permissions table and match the sql login with the ... 'permissions' in the profile, and if the query returns a value such as 2, ... Best Regards, ... except for the fact that I can't use NT domain groups. ...
    (microsoft.public.sqlserver.security)
  • Re: How to copy/paste text from a form to email
    ... Best regards, ... Alex Dybenko (MVP) ... with the SQL part. ... "Alex Dybenko" wrote: ...
    (microsoft.public.access.modulesdaovba)