0

Universal Connector timeout

Jet Reports Historic Posts

October 19, 2011 20:22

None

Follow

What is the current timeout value for the Universal Connector. I have some longer running queries that are timing out for a particular report I am working on. Can this be changed? and where?

• Facebook
• Twitter
• LinkedIn

2 comments

• 
  Jet Reports Historic Posts October 19, 2011 21:55 Official comment

  Hi Tim,
  
  Yes it can be changed although not the Jet user interface. You have to actually edit the Jet data sources.xml file manually. First make sure all instances of Excel are completely closed. Then go to:
  
  %appdata%\Jet Reports
  
  Find the file "Data Sources.xml" and open it with Notepad (or your favorite text editor).
  
  Find the text:
  
  <dataSource name="[My Data Source]"
  where [My Data Source] is the name of your data source. Then directly under that data source look for
  
  <setting name="CommandTimeout" type="Integer" encrypted="false"> <value>30</value> </setting>
  You can change the value from 30 to any number of seconds necessary for your queries to complete. Does that help?
  
  Regards,
  Hughes

• 0
  
  Jet Reports Historic Posts October 20, 2011 02:10

  Yup Got it. I'm using sql to store the datasources, so I updated the values there.
  thanks