Very Computer

by **Srini** » Fri, 19 Oct 2001 15:04:07

When I try to use sp_xml_preparedocument or any other xml
stored procedure I get the error:

XML stored procedures are not supported in fibers mode

I am running sql 2000. Any ideas??

any Help is greatly appreciated..
thankz

by **Bryant Like** » Sat, 20 Oct 2001 07:55:16

Quote:> When I try to use sp_xml_preparedocument or any other xml
> stored procedure I get the error:

> XML stored procedures are not supported in fibers mode

Sounds like you are running in fibers mode. See this page for more
information:
http://msdn.microsoft.com/library/en-us/entrmgr/em_269f.asp

Turn off the fibers mode and then you should be able to use the XML stored
procedures.

--
Bryant

by **watters** » Sun, 06 Jan 2002 09:17:35

I've found that it's a difference in the version of MDAC that you're
using. I get that failure if I access the database, which has MDAC 2.7
installed on the server, with a machine that has MDAC 2.6, but not if
it's got MDAC 2.5. So, you have a choice, turn off fiber mode within SQL
Server, or make sure that your MDACs match. HTH.

--
Posted via dBforums
http://dbforums.com