The Baretta

Wow that's a long heading...  Let me explain how this is done, and why this path was chosen out of all the options. THE OPTIONS Still to come... SETTING UP There's quite a few large steps to get this done, so I'll split it into the following sections, ensuring we test along the way to make sure we haven't missed a step: Install & Configure Oracle Client on Web Server Create custom Web Service in Visual Studio Deploy Web Service to IIS Build InfoPath Form Configure InfoPath Services Deploy InfoPath Form to SharePoint Environment Install & Configure Oracle Client on Web Server Ask your Oracle DBA what version of Oracle the database is running on. Navigate here and download the corresponding Client (for this excercise get the 32-bit version if its an option):  http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Copy to the IIS Server (Web Front End) Extract and install, here's the settings I used for the i...

Deploying an InfoPath form Once you have developed your InfoPath form, most likely you will need to deploy/publish it to SharePoint so that the information can be stored and reported on.  There are different methods for deployment, which are also dependent on whether you are publishing a fresh form, or updating an old form. Two methods of Deploying/Publishing Forms When it comes time to deploy your form to SharePoint, there are two different methods with reasons for and against why and when you would use each.  You can publish the form as a Form Library, or as a SharePoint Content Type. Deployment Method 1:  As a Form Library When you publish a form as a Form Library, it will create the library on the SharePoint Site of your choosing, and a copy of the form template can be found here:  http://rootsite/formlibrary/forms/template.xsn Use this method when you only require one library for the forms and the forms do not get consumed by BizTalk for some ...