InfoPath Dev

I am getting timeouts against from SQL views because the query is talking more than 30 seconds.

I found this previous posting on how to increase the timeout

http://www.infopathdev.com/forums/t/11369.aspx

However I cant seem to find a solutioon for IP 2010.

Can someone take the IP2007 info and translate for me to IP 2010?

Thanks

While the InfoPath object model did change for 2010, the code should be very similar. I will ask one of our support staff to respond with more detail. 

Hi oldradio99,

Here's a code you could use for an SQL query connection:

AdoQueryConnection dc = DataConnections["PutDataConnectionNameHere"] as AdoQueryConnection;
            if (dc != null)
            {
                dc.Timeout = 300;
                dc.Execute();
            }

You might also like to check qRules' QueryData command. It can be used with databases, web services, XMLs, and SharePoint Library Submit connections. What's great about this is that it allows extending the data connection timeout without writing any code. Hope this helps.

When I go to set my programming language on the Forms options I only have C# and VB.

 I do not have an Option for JavaScript.

I found where Hilary posted a VB script so I used this but I get a build error.

Sub FormEvents_Loading(ByVal sender As Object, ByVal e As LoadingEventArgs)

Dim dAdapt

dAdapt = XDocument.DataAdapters(

"Main connection")

dAdapt.Timeout = 120

'Increase to 60 seconds - Default is 30

dAdapt.Query()

'Issue the query

End Sub

Made a minor change but now I am getting a message that XDocument is not declared.

Public Sub FormEvents_Loading(ByVal sender As Object, ByVal e As LoadingEventArgs)

Dim dAdapt As Object

dAdapt = XDocument.DataAdapters(

"Main Connection")

dAdapt.Timeout = 60

'Increase to 60 seconds - Default is 30

dAdapt.Query()

'Issue the query

End Sub

End Class

Hi oldradio99,

Sorry for the confusion, the code provided is in C#. VB Script is a bit different with Visual Basic, and the code you're using won't work as a Visual Basic code. I recommend using the previous code in C# for your SQL query connection. Let me know if this helps.

Yahoo!  That worked.  Thank you!

But now have a question.  This change loads the data on form load.  I would prefer the SQL query to run with this time-out extension based on the Run Query Button.

Where would I insert that code and would the same code work?

Thanks Again.

Art

 I think the timeout setting from form load will persist - so try removing the line that executes the query:

 dc.Execute();

And then running the query from your button.

I did come up with a question.

When setting the programming language in Form Options it asks for a location.

Does that location need to be a network location where everyone has access or does it not matter since the code is in the form?

Local. It will include the DLL in the XSN.