Unfortunately I've found nothing else concrete.  I've had a few suggestions
to reinstall the .net framework or Visual Studio.  You may want to give
that a try before rebuilding the machine.

Larry Franks

This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
--------------------
| Thread-Topic: BizTalk 2004: MissingMethodException when adding SQL
Adapter S
| thread-index: AcRZ8d3QLT3Yx7p5Q/CRIH0xgPnXlA==
| X-WBNR-Posting-Host: 24.169.82.178
| From: "examnotes"
<firstname.at.firstnamelastname@online.nospam>
| References:  <367991B3-C23F-4679-A18B-0A95B775C7E7@microsoft.com>
<akHgKH9VEHA.1996@cpmsftngxa10.phx.gbl>
<956135CA-6966-4BD0-82F1-2A392BAAA814@microsoft.com>
<5UYzazUWEHA.2764@cpmsftngxa10.phx.gbl>
| Subject: RE: BizTalk 2004: MissingMethodException when adding SQL Adapter
S
| Date: Thu, 24 Jun 2004 06:48:01 -0700
| Lines: 189
| Message-ID: <7C1E89D0-23F7-4064-A0D2-160A360D0DAD@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| 	charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.biztalk.tools
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.tools:3819
| X-Tomcat-NG: microsoft.public.biztalk.tools
|
| Thanks, Larry. I've gotten to the point where I will have to rebuild my
development workstation this weekend if this doesn't do the trick, so I'm
*very* interested in any additional information you can find.
|
| ""larry franks"" wrote:
|
| > Well, so-far the only recommendations I've found are to reinstall
SQLXML,
| > which I see from other threads that you've tried already.  I'll keep
| > digging and see what other information I can find on this.
| >
| > Larry Franks
| >
| > This posting is provided "AS IS" with no warranties,and confers no
rights.
| > Subscribe at
| >
http://support.microsoft.com/defaul...msdn/nospam.asp
| > &SD=msdn
| > --------------------
| > | Thread-Topic: BizTalk 2004: MissingMethodException when adding SQL
| > Adapter S
| > | thread-index: AcRX6puKAajgzI6bTfKOmiUgfeY1vg==
| > | X-WBNR-Posting-Host: 24.169.82.178
| > | From: "examnotes"
| > <firstname.at.firstnamelastname@online.nospam>
| > | References:  <367991B3-C23F-4679-A18B-0A95B775C7E7@microsoft.com>
| > <akHgKH9VEHA.1996@cpmsftngxa10.phx.gbl>
| > | Subject: RE: BizTalk 2004: MissingMethodException when adding SQL
Adapter
| > S
| > | Date: Mon, 21 Jun 2004 16:51:01 -0700
| > | Lines: 123
| > | Message-ID: <956135CA-6966-4BD0-82F1-2A392BAAA814@microsoft.com>
| > | MIME-Version: 1.0
| > | Content-Type: text/plain;
| > | 	charset="Utf-8"
| > | Content-Transfer-Encoding: 7bit
| > | X-Newsreader: Microsoft CDO for Windows 2000
| > | Content-Class: urn:content-classes:message
| > | Importance: normal
| > | Priority: normal
| > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | Newsgroups: microsoft.public.biztalk.tools
| > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| > | Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.tools:3799
| > | X-Tomcat-NG: microsoft.public.biztalk.tools
| > |
| > | Larry:
| > |
| > |     Thanks for the quick reply. Here is the information you requested:
| > |
| > | System.Data
| > | * Version: 1.0.5000.0
| > | * PK Token: b77a5c561934e089
| > |
| > |     To the best of my knowledge I am not having any other problems
with
| > XmlReader. I am not using it explicitly in any of my current projects,
but
| > I have not received any similar errors in any other applications.
| > |
| > | Matthew
| > |
| > | ""larry franks"" wrote:
| > |
| > | > Hi Matthew, I haven't seen this error and can find no BizTalk
specific
| > | > reference to it.  From the error it sounds like our assembly for
the
| > wizard
| > | > is having a problem accessing System.Xml.XmlReader.
| > | > Can you browse to \winnt\assembly and find the system.data
entrie(s)
| > and
| > | > let me know the version numbers and the public key token value for
| > these.
| > | >
| > | > Do you have anything else that uses the XmlReader?  Specifically it
| > looks
| > | > like ExecuteXmlReader() may be what's failing.
| > | >
| > | > Larry Franks
| > | >
| > | > This posting is provided "AS IS" with no warranties,and confers no
| > rights.
| > | > Subscribe at
| > | >
| >
http://support.microsoft.com/defaul...msdn/nospam.asp
| > | > &SD=msdn
| > | > --------------------
| > | > | Thread-Topic: BizTalk 2004: MissingMethodException when adding
SQL
| > | > Adapter Schem
| > | > | thread-index: AcRXvZ/nm6MSWDXXQjmypdpNvU5mag==
| > | > | X-WBNR-Posting-Host: 24.169.82.178
| > | > | From: "examnotes"
| > | > <firstname.at.firstnamelastname@online.nospam>
| > | > | Subject: BizTalk 2004: MissingMethodException when adding SQL
Adapter
| > | > Schem
| > | > | Date: Mon, 21 Jun 2004 11:29:01 -0700
| > | > | Lines: 44
| > | > | Message-ID: <367991B3-C23F-4679-A18B-0A95B775C7E7@microsoft.com>
| > | > | MIME-Version: 1.0
| > | > | Content-Type: text/plain;
| > | > | 	charset="Utf-8"
| > | > | Content-Transfer-Encoding: 7bit
| > | > | X-Newsreader: Microsoft CDO for Windows 2000
| > | > | Content-Class: urn:content-classes:message
| > | > | Importance: normal
| > | > | Priority: normal
| > | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| > | > | Newsgroups: microsoft.public.biztalk.tools
| > | > | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
| > | > | Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| > | > | Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.tools:3797
| > | > | X-Tomcat-NG: microsoft.public.biztalk.tools
| > | > |
| > | > | Greetings:
| > | > |
| > | > |     This is a duplicate of a post I made last week. I am
re-posting
| > it
| > | > using my newly-updated profile so that I can get the "response
within
| > two
| > | > business days" as an MSDN Universal subscriber. I apologize for the
| > | > duplicate message.
| > | > |
| > | > |     I regularly receive this error in visual studio when
attempting
| > to
| > | > add a SQL Adapter "generated item" to my BizTalk project in Visual
| > Studio
| > | > 2003:
| > | > |
| > | > | ---------------------------
| > | > | Microsoft Development Environment
| > | > | ---------------------------
| > | > | The following exception has occurred:
| > | > |
| > | > | MissingMethodException: Method not found: System.Xml.XmlReader
| > | > Microsoft.Data.SqlXml.SqlXmlCommand.ExecuteXmlReader().
| > | > | ---------------------------
| > | > | OK
| > | > | ---------------------------
| > | > |
| > | > |     Sometimes the error goes away when I reboot my system, but as
| > often
| > | > as not, it does not. This is particularly frustrating, especially
as I
| > can
| > | > find no mention of this error in the BizTalk Server documentation
or
| > these
| > | > groups.
| > | > |
| > | > |     Here are steps to reproduce:
| > | > | * Add | Generated items
| > | > | * Add Adapter | SQL adapter
| > | > | * Select local SQL Server and only available BizTalk database
| > | > | * Select existing port (error also occurs when manually entering
| > | > connectionstring)
| > | > | * Port type: Send port
| > | > | * Target namespace: http://foo
| > | > | * Request root element name: Request
| > | > | * Response root element name: Response
| > | > | * Statement type: Stored procedure (error also occurs when
selecting
| > | > "Updategram")
| > | > | * Error listed above occurs when clicking "Next"
| > | > |
| > | > |     At this point you can click "back" and "next" again without
| > receiving
| > | > the error, but the following screen of the wizard is empty of all
| > | > information (there are no stored procedures to choose in the list),
and
| > you
| > | > cannot proceed.
| > | > |
| > | > |     This is my development configuration (everything is running
on
| > the
| > | > same workstation):
| > | > |
| > | > | * BizTalk 2004 developer edition
| > | > | * SQL Server 2000 developer edition, all SPs
| > | > | * Visual Studio 2003 Enterprise Architect edition
| > | > | * Windows XP Professional, SP1, all patches
| > | > | * Windows integrated security - BizTalk service account and my
dev
| > | > account are both members of db_owner role in target database (the
same
| > | > error also occurs when connecting as 'sa' using SQL Server security)
| > | > |
| > | > |     Can anyone on the BizTalk team please address this error? I
have
| > been
| > | > unable to find any particular sequence of events that will cause it
to
| > | > succeed or fail; obviously there is some logic at work here but I
have
| > been
| > | > unable to find it. Thanks in advance for your assistance!
| > | > |
| > | > | Matthew
| > | > |
| > | > |
| > | >
| > | >
| > |
| >
| >
|

[ Post a follow-up to this message ]