Data Connections

Re: SQL timeouts in IP 2010

Patrick Halstead — Sun, 08 Sep 2013 22:14:04 GMT

Local. It will include the DLL in the XSN.

Re: SQL timeouts in IP 2010

oldradio99 — Fri, 06 Sep 2013 15:00:21 GMT

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?

Re: SQL timeouts in IP 2010

oldradio99 — Wed, 04 Sep 2013 15:23:39 GMT

Thanks

Re: SQL timeouts in IP 2010

Hilary Stoupa — Wed, 04 Sep 2013 15:05:46 GMT

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.

Re: SQL timeouts in IP 2010

oldradio99 — Wed, 04 Sep 2013 13:10:58 GMT

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

Re: SQL timeouts in IP 2010

donstephen — Wed, 04 Sep 2013 04:49:34 GMT

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.

Re: SQL timeouts in IP 2010

oldradio99 — Tue, 03 Sep 2013 19:04:26 GMT

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

Re: SQL timeouts in IP 2010

oldradio99 — Tue, 03 Sep 2013 15:38:30 GMT

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.

Public

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

Re: SQl timeouts in IP 2010

donstephen — Mon, 02 Sep 2013 06:09:02 GMT

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.

Re: SQl timeouts in IP 2010

Patrick Halstead — Sun, 01 Sep 2013 20:52:04 GMT

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.

SQl timeouts in IP 2010

oldradio99 — Fri, 30 Aug 2013 14:41:21 GMT

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