Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Error in Visual Studio 2008…

 .NET, General, SQL  No Responses »
Jul 232009
 

In VS 2008 Menu select Tools and from the Options window, select Database Tools > Data Connections.

Make sure the SQL Server Instance Name(blank for default) – is set to the instance of SQLExpress installed.

You may leave this blank if only one instance is installed

 Posted by at 10:53 am  Tagged with: , , ,

OpenXML: XML parsing error: Reference to undeclared namespace prefix:

 .NET, BizTalk, SQL  No Responses »
Nov 082007
 

I ran into a small issue using an XML document type in SQL 2005 from BizTalk 2006 R2 and it turn our to be a namespace pass in from the sp_xml_preparedocument statement in my stored procedure.

You need to set it up as follows:
EXECUTE sp_xml_preparedocument @idoc OUTPUT, @xmlMessage, ‘<root xmlns:ns1=”http://namespacename” />’

The ‘<root xmlns:ns1=”http://namespacename” />’ being the most important part as this defines the namespace from the first part of your message.

Then your OPENXML call can be set up using the namespace – i.e /ns1:<node> etc.

 Posted by at 1:06 pm  Tagged with: , , , ,
© 2011 Greg Leonardo Suffusion theme by Sayontan Sinha
show
 
close