Connecting to Microsoft SQL Server

In many enterprise settings, it is likely that Microsoft SQL Server will be the database of choice, rather than Microsoft Access. Connection to a Microsoft SQL Server database is supported using the Data Source Setup Wizard in InfoPath 2003.

The following example will demonstrate the use of InfoPath 2003 with Microsoft SQL Server 2000 SP3. The example makes use of the pubs (publishers) sample database provided with SQL Server 2000. The example assumes that the SQL Server instance is installed on the local machine. If you have installed SQL Server on another machine, make appropriate adjustments at the stage where the data source is chosen.

Using the Data Source Setup Wizard

There are many similarities to using ...

Get Microsoft® Office InfoPath™ 2003 Kick Start now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.