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 ...