SQL DataConnection in InfoPath forms: Part 1

We can set our InfoPath forms to receive SQL data. In order to do that we need have a

A SharePoint library to hold our data connection files. Our list will use this data connection to retrieve rows from SQL DB. Its fairly straightforward to create a library in SP site.

Go to your SharePoint site -> Libraries->Create->Data Connection Library, give your library a name. (My Data Connections)

Now we have a ‘My Data Connections’  library to hold all the connections. It is important to have it at the root site level so that we can use it for all our sub-sites forms too if needed.

Now in our InfoPath form, we need to create a SQL Data Connection from the Data->Data Connections->Add.

Create a new connection to: Receive data

Select the source of your data to Database(Microsoft SQL Server only)

Select Database ->New Source

Enter the server name

Choose the database, table you want to use in your InfoPath form.

Save the Data Connection File and Finish.

We have our new SQL data connection which can be used to   populate any control we want within the InfoPath form.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s