|
Home > Archive > BizTalk Server Tools > June 2004 > BizTalk 2004: MissingMethodException when adding SQL Adapter Schem
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk 2004: MissingMethodException when adding SQL Adapter Schem
|
|
| Matthew Roche 2004-06-26, 10:53 am |
| 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 advan
ce for your assistance!
Matthew
| |
| larry franks 2004-06-26, 10:53 am |
| 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
|
|
| |
| Jan Eliasen 2004-06-26, 10:53 am |
| Hi.
Have you tried reinstalling sqlxml ?
Jan Eliasen
On Mon, 21 Jun 2004 11:29:01 -0700, "Matthew Roche"
<firstname.at.firstnamelastname@online.nospam> wrote:
>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 adva
nce for your assistance!
>
>Matthew
--
Jan Eliasen, representing himself and not the company he works for.
| |
| Jan Eliasen 2004-06-26, 10:53 am |
| Perhaps msxml 3 or 4?
Jan Eliasen
On Tue, 22 Jun 2004 08:36:47 +0200, Jan Eliasen <spam@eliasen.dk>
wrote:
[vbcol=seagreen]
>Hi.
>
>Have you tried reinstalling sqlxml ?
>
>Jan Eliasen
>
>On Mon, 21 Jun 2004 11:29:01 -0700, "Matthew Roche"
><firstname.at.firstnamelastname@online.nospam> wrote:
>
ance for your assistance![vbcol=seagreen]
--
Jan Eliasen, representing himself and not the company he works for.
| |
| Matt Milner 2004-06-26, 10:53 am |
| Are you sure you have sqlxml 3.0 sp2 installed?
Matt
"Matthew Roche" <firstname.at.firstnamelastname@online.nospam> wrote in
message news:367991B3-C23F-4679-A18B-0A95B775C7E7@microsoft.com...
> 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
>
|
|
|
|
|