BizTalk Server General - SQL Adapter and SQL Server 7

Author

SQL Adapter and SQL Server 7

Andrew Babiec

2006-04-10, 7:34 pm

Does the BizTalk 2004/2006 SQL Adapter work with SQL Server 7.0?

Alan Smith

2006-04-11, 8:45 am

Hi,

I'm just guessing here, but the SQL Adapter uses the xml functionality (FOR
XML AUTO) in SQL server to get the reesults from a SP call into xml, and i
don't think this functionality is available in SQL Server 7.

You may want to take a look at the ODBC adapter on GotDotNet, it would be
worth building a POC and seeing if this can work agianast SQL 7. The link is
here...

http://www.gotdotnet.com/Workspaces...35-76ea42e45de4

Regards,

Alan

--
The Bloggers Guide to BizTalk
http://geekswithblogs.com/asmith

"Andrew Babiec" wrote:

> Does the BizTalk 2004/2006 SQL Adapter work with SQL Server 7.0?
>