Failed to load msxmlsql.dll

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
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
>
>
|||Hi Ronen, is this still a problem?
Thanks
Michael
"Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...[vbcol=seagreen]
> 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:
|||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@.online.microsoft.com> wrote in message
news:uYhiD3QAGHA.532@.TK2MSFTNGP15.phx.gbl...
> Hi Ronen, is this still a problem?
> Thanks
> Michael
> "Galex Yen [MSFT]" <galexy@.online.microsoft.com> wrote in message
> news:E170E5C3-C63A-428F-9438-73DA4CBB680F@.microsoft.com...
>

extracting data from a varchar variable?

Guys.

I have some data like this one:

'Uploadfiles\CompanyID\ProjectCode\Files\File1.doc'

P.S: the values may vary each time.

I need to programmatically extract from that kind of string only file1.doc

Ho can I dynamically do it? any function? statement? etc? please help.

The idea is getting only the string after the last "\"

Thanks
Frdeclare @.t varchar(256)

select @.t = 'Uploadfiles\CompanyID\ProjectCode\Files\File1.doc'

select reverse(substring(reverse(@.t),1,patindex('%\%',reverse(@.t))-1))