Topics from the Microsoft SQL Server Protocols team - Netlibs, TDS, SQL Browser, etc.
There have been questions raised about how to make InfoPath work with SQL 2005 native web services. Some people have been hitting the following error in InfoPath when trying to use SQL 2005 native web services as a data source:
One such scenario was raised in the posting on MSDN SQL Server Data Access forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=128790&SiteID=1
We are continuing to work with the InfoPath team to provide the best possible user experience, but due to the different release schedules it may require some workarounds in the meantime.
With the current release of both products (InfoPath 2003 and SQL 2005), the following are things to consider while developing an InfoPath form using the SQL 2005 native web services support:
This is in effect the scenario mentioned in the forum posting, which is the main type of scenario that is currently possible when using InfoPath with SQL 2005 over web services.
Jimmy Wu, SQL Server Protocols Disclaimer: This posting is provided “AS IS” with no warranties, and confers no rights