Failed to load msxml2.dll - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Failed to load msxml2.dll

Author

Topic

cykophysh
Starting Member

24 Posts

Posted - 2007-07-23 : 09:07:20

I am running SQL 2000 and SQL 2005 on Vista box. When I am trying to open XML in a SP in
SQL 2000

EXEC sp_xml_preparedocument @idoc OUTPUT, @xmlstring

I am getting this error. Any help?

Kind Regards,
Gary

MightyGorilla
Starting Member

7 Posts

Posted - 2007-07-23 : 09:39:58

Try reloading the xml components?
Just a guess...

[url]http://www.microsoft.com/downloads/details.aspx?familyid=993c0bcf-3bcf-4009-be21-27e85e1857b1&displaylang=en[/url]

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-07-23 : 10:09:03

are you running MSDE, or is it actually SQL Server? what service pack is installed?

-ec

cykophysh
Starting Member

24 Posts

Posted - 2007-07-23 : 18:24:17

eyechart,
I am running SQL 2000 not the MSDE version, I have service pack 3 installed.

I tried reinstalling the components but that didn't help

Kind Regards,
Gary

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-23 : 18:37:43

I didn't think sp3 for SQL Server 2000 worked on Vista.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

cykophysh
Starting Member

24 Posts

Posted - 2007-07-23 : 19:09:52

it seemed to install ok,
was a while back when I installed it, so can't really remember issues
I remember when I installed SQL 2000, it vista did warn me that it was incompatible withe SQL2000 but it did install, I can query the DB no problem.

Kind Regards,
Gary

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-07-23 : 19:28:58

Perhaps this is an instance where it doesn't work on Vista.

Tara Kizer
http://weblogs.sqlteam.com/tarad/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-07-23 : 20:07:47

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=384154

Peter Larsson
Helsingborg, Sweden

cykophysh
Starting Member

24 Posts

Posted - 2007-07-24 : 04:07:12

quote:
Originally posted by Peso

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=384154

Peter Larsson
Helsingborg, Sweden

Thanks peter that is my thread on SQlserver central I have searched the internet and cannot find a thread with an answer

Kind Regards,
Gary

cykophysh
Starting Member

24 Posts

Posted - 2007-07-24 : 04:13:47

quote:
Originally posted by Peso

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=338&messageid=384154

Peter Larsson
Helsingborg, Sweden

[url]http://www.topxml.com/SQLXML/rn-277253_Failed-to-load-Msxml2-dll.aspx[/url]
[url]http://www.sql-server-performance.com/forum/post.asp?method=ReplyQuote&REPLY_ID=60140&TOPIC_ID=12931&FORUM_ID=14[/url]
[url]http://www.topxml.com/SQLXML/rn-277253_Failed-to-load-Msxml2-dll.aspx[/url]
[url]http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/4bdd4ccd0b280651/58cce051bb3c5265?lnk=gst&q=failed+to+load+msxml2.dll&rnum=1#58cce051bb3c5265[/url]

I found this hot fix and installed it and it didn't help
[url]http://support.microsoft.com/kb/823490[/url]
Kind Regards,
Gary

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2007-07-24 : 11:48:07

it looks like sql2k is not supported on vista at all http://www.microsoft.com/sql/prodinfo/previousversions/faq-sql_on_vista.mspx

-ec

cykophysh
Starting Member

24 Posts

Posted - 2007-08-06 : 10:15:20

quote:
Originally posted by eyechart

it looks like sql2k is not supported on vista at all http://www.microsoft.com/sql/prodinfo/previousversions/faq-sql_on_vista.mspx

-ec

Thanks, I never did have any luck with it, so I uninstalled SQL 2000 on vista and developed on a Machine with XP.
Everything works fine

Kind Regards,
Gary

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources