2 Ways to connect InfoPath to SQL Server 2012 Express
Learn two ways in which you can connect an InfoPath 2010 form to a SQL Server 2012 Express database.
Not too long ago, Microsoft released a new version of SQL Server: SQL Server 2012. And as you may already know, SQL Server has a free edition called Express, which you can install locally on your desktop computer.
Because I have seen a few people asking whether you can use InfoPath 2010 with SQL Server Express, I decided to give it a try. While I don’t generally use the Express edition of SQL Server, I did expect it to work with InfoPath just like the Standard, Developer, and Enterprise editions of SQL Server do.
There are two types of data connections you can create in InfoPath:
- Data connections to retrieve data
- Data connections to submit data
Both these types of data connections can be used to connect an InfoPath form to a SQL Server 2012 Express database. And in the InfoPath video tutorial below, I show you how you can connect an InfoPath 2010 form to a SQL Server 2012 Express database to retrieve or submit data.
If you prefer to read about the method used to connect InfoPath to SQL Server to submit data, you can also refer to a previous article I wrote about connecting InfoPath to SQL Server 2008, since the method has not changed with going from SQL Server 2008 to SQL Server 2012.
Because SQL Server Express can be installed on a desktop computer, you can also limit the design of your InfoPath form templates to exclusively target InfoPath Filler 2010, instead of a browser.
This should allow you to use controls (that are ordinarily not available when you are designing an InfoPath browser-compatible form template) such as the InfoPath Master/Detail control, which I will show you how to hook up to tables that have a one-to-many relationship between them in a SQL Server 2012 Express database in an upcoming InfoPath video tutorial about using InfoPath with SQL Server Express.
Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent of S.Y.M. Wong-A-Ton. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author, S.Y.M. Wong-A-Ton.