Q&A
Q. | Can I bind an InfoPath form to tables of databases other than Access or SQL Server 2000? |
A. | Yes, but you must write custom code to connect to other databases. An alternative for Oracle and other databases that have .NET native or ODBC data providers is to create a Microsoft ASP.NET XML Web service that connects to the Oracle database and use the Data Connection Wizard to consume the Web service. You’ll find a detailed example of this approach at www.perfectxml.com/InfoPathOracle.asp. |
Q. | Is there any limit to the number of secondary data sources for an InfoPath form? |
A. | No. You can add as many secondary data sources as you need to populate list box controls. To minimize form opening delays and stress on the underlying database, it’s a good practice ... |
Get Introducing Microsoft® Office InfoPath™ 2003 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.