In setting up the InfoPath forms Server, I successfully installed the SharePoint services application. I then installed and started to configure the InfoPath forms server. I got to the 8th step and it eventually time out stating that it could not connect to the Microsoft##SSEE database, that I needed to make sure that remote connections were enabled.

I went to this KB article and configured the SSEE database for remote connections. I was still getting the error on configuration.

What I ended up realizing was that the SSEE database is an orphaned database that should not be installed. I then needed to uninstall the database and re-configure the forms server. Here are the steps to uninstall the Microsoft##SSEE database:

1. In the registry browse to this location: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall
2. Click on each of the sub folders {GUID} on the left hand column and look at the display name on the right until you see “Microsoft SQL 2005 embedded Edition…”
3. Copy the value that is stored as the UninstallString (for example:  MsiExec.exe /X{0F51A262-1ADF-4914-B448-78AC58C4178A})
4. Open up a command prompt and paste the value and add to the end of the string ” CALLERID=OCSETUP.EXE”
5. Example  c:\Temp\MsiExec.exe /X{0F51A262-1ADF-4914-B448-78AC58C4178A} CALLERID=OCSETUP.EXE

I am heading up to Redmond for a couple of conferences:

and

Let me know if you are going, it would be great to meet you! 

Wouldn’t it be nice to open an InfoPath form from another form, and “jump” to a particular row in the database that is being referenced?

That was my question, and it took some questioning, searching, etc to get the answer. (Thanks to http://www.infopathdev.com, and http://msdn.microsoft.com)

So here it goes, I have a form that I query and get the results, and then I want to jump to another form based on my results.

I created a button, and then edited the button.

Here is the actual code, in which I will comment on it after:

function OpenDetail::OnClick(eventObj)
{
//Get the local file path
var sFormPath = “”;
var sUri = XDocument.Solution.URI;
var i = sUri.lastIndexOf(”");
if(-1 == i)
i = sUri.lastIndexOf(”/”);
sFormPath = sUri.substring(0, i + 1);

//Get the Parent ID form this form
var param1=XDocument.DOM.selectSingleNode(”/dfs:myFields/dfs:dataFields/d:ContactInfo/@ID”).text;

//Start the application
var oApp = new ActiveXObject(”InfoPath.Application”);

//Open an InfoPath document from the published template
var oXDocumentCollection = oApp.XDocuments;
var oXDocument = oXDocumentCollection.NewFromSolution(sFormPath+”detail.xsn”);

// Get pointers to the target fields
var oID = oXDocument.DOM.selectSingleNode(”//@parentid”);

//Update the fields
oID.text = param1;

oXDocument.Query();
}

The first part gets the local directoy (assuming that both forms are located in the same directory.
The second part grabs the data from the ‘parent’ form that is going to be used to key the second form.
{The rest of the code’s comments explain what is going on.}

Once that the variable is filled, then we can run the Query() function to return the data.

The issues that I am having right now is that when you open up the new form, you get 3 security warning messages, so I am looking at how to get rid of those dialog boxes.