Thanks, Larry. I've gotten to the point where I will have to rebuild my deve
lopment 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
> [url]http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp[/ur
l]
> &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 Adapte
r
> 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
> | >
> [url]http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp[/ur
l]
> | > &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 Adapte
r
> | > 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.g
bl
> | > | 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), an
d
> 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 ]