InfoPath Dev

is there a way to lengthen the "Time out" on the form submit? Im Googling and nothing right now.

The ADOAdapter object has a Timeout property that is used by the ADO data adapter during submit and retrieve data operations from an ActiveX Data Objects/OLEDB external data source.

You should be able to do something like this:

var oAdapter = XDocument.DataObjects ("MyDataConnection").QueryAdapter;
oAdapter.Timeout = 60;
XDocument.DataObjects("MyDataConnection").Submit();

I haven't tried this myself, so let me know if it works.


Greg Collins [InfoPath MVP]

Hmm, i have a small problem with this. Its telling me.

"An item with the following index deos not exist in the collection:Main Connection"

Main connection is the data connection that i need extended. This looks to be a very simple procedure. Because it looks like you create the connection thats to be changed and then chenge it , then submit the change . Am i wrong?

Okay, it looks like what you are looking for is XDocument.QueryAdapter, but this will only work if your main connection is a database or web service. If you have an XML file as your main data source, then the QueryAdapter will be null.

The DataAdapters is only for secondary data sources.

I hope this helps!

Greg Collins [InfoPath MVP]

Its a SQL connection.

Great -- so just to clarify, you'll want to specify the new timeout this way:

XDocument.QueryAdapter.Timeout = 60; // or whatever length you want.

Greg Collins [InfoPath MVP]

Wow thats seems to have done the trick. Thanks Greg.

Glad to help out!

Greg Collins [InfoPath MVP]