| Matthew Roche 2004-06-20, 11:10 pm |
| Greetings:
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
|