| Matthew Roche 2004-06-26, 10:53 am |
| 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: "=?Utf-8?B?TWF0dGhldyBSb2NoZQ==?="
> <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
> |
> |
>
>
|