Hi,

Any resolution to your issues? I am seeing a big drop in query performance since I installed 2005 sp4, queries taking tens of hours instead of a couple of hours.

Not...

I found two versions of odbc32.dll, identical apart from file size, one in C:\Windows\system32 and one in C:\WINDOWS\SysWOW64. Tried both in each location and still got the same error. One...

Well it turns out that this can be made to work by using a conversion function within the XML producing query, converting the output to varchar(max), then using REPLACE to...