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 da
ys" 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.Dat
a.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 m
ention 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 connections
tring)
* 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 "Update
gram")
* Error listed above occurs when clicking "Next"

At this point you can click "back" and "next" again without receiving the er
ror, but the following screen of the wizard is empty of all information (the
re are no stored procedures to choose in the list), and you cannot proceed.

This is my development configuration (everything is running on the same work
station):

* 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 a
re both members of db_owner role in target database (the same error also occ
urs 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 f
ind it. Thanks in advan
ce for your assistance!

Matthew

[ Post a follow-up to this message ]

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 ]

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 usin
g my newly-updated profile so that I can get the "response within two busine
ss days" as an MSDN Universal subscriber. I apologize for the duplicate mess
age.
>
>    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.Da
ta.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 group
s.
>
>    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 connection
string)
>* 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 "Updat
egram")
>* Error listed above occurs when clicking "Next"
>
>    At this point you can click "back" and "next" again without receiving t
he 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 proc
eed.
>
>    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 oc
curs 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; obvio
usly there is some logic at work here but I have been unable to find it. Thanks in a
dva
nce for your assistance!
>
>Matthew

--
Jan Eliasen, representing himself and not the company he works for.

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]

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
>

[ Post a follow-up to this message ]