<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: ODBC - Get Collection - command timeout. Is it possible to extend? in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/ODBC-Get-Collection-command-timeout-Is-it-possible-to-extend/m-p/101867#M48728</link>
    <description>I think the default is 30 seconds a tweak to the code stage is required. Find the line where the odbcCommand object is created and add a line after it to set the &lt;EM&gt;CommandTimeout&lt;/EM&gt; property. For example:&lt;BR /&gt;&lt;BR /&gt;oCommand = New System.Data.odbc.odbcCommand&lt;BR /&gt;&lt;STRONG&gt;oCommand.CommandTimeout = 60&lt;/STRONG&gt;&lt;BR /&gt;</description>
    <pubDate>Wed, 24 Mar 2021 16:06:27 GMT</pubDate>
    <dc:creator>John__Carter</dc:creator>
    <dc:date>2021-03-24T16:06:27Z</dc:date>
    <item>
      <title>ODBC - Get Collection - command timeout. Is it possible to extend?</title>
      <link>https://community.blueprism.com/t5/Product-Forum/ODBC-Get-Collection-command-timeout-Is-it-possible-to-extend/m-p/101866#M48727</link>
      <description>​​Hello all!&lt;BR /&gt;&lt;BR /&gt;I'm using ODBC Object Get Collection to run a complex SQL and return the results as a Collection in BP.&lt;BR /&gt;&lt;BR /&gt;The query is taking approx. 45 seconds to run, and so is timing out every time I run it in BP. Is it possible to extend this to say, 1 minute? I've looked everywhere but couldn't find a solution!&lt;BR /&gt;&lt;BR /&gt;Cheers!</description>
      <pubDate>Wed, 24 Mar 2021 14:24:05 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/ODBC-Get-Collection-command-timeout-Is-it-possible-to-extend/m-p/101866#M48727</guid>
      <dc:creator>DavidWood</dc:creator>
      <dc:date>2021-03-24T14:24:05Z</dc:date>
    </item>
    <item>
      <title>Re: ODBC - Get Collection - command timeout. Is it possible to extend?</title>
      <link>https://community.blueprism.com/t5/Product-Forum/ODBC-Get-Collection-command-timeout-Is-it-possible-to-extend/m-p/101867#M48728</link>
      <description>I think the default is 30 seconds a tweak to the code stage is required. Find the line where the odbcCommand object is created and add a line after it to set the &lt;EM&gt;CommandTimeout&lt;/EM&gt; property. For example:&lt;BR /&gt;&lt;BR /&gt;oCommand = New System.Data.odbc.odbcCommand&lt;BR /&gt;&lt;STRONG&gt;oCommand.CommandTimeout = 60&lt;/STRONG&gt;&lt;BR /&gt;</description>
      <pubDate>Wed, 24 Mar 2021 16:06:27 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/ODBC-Get-Collection-command-timeout-Is-it-possible-to-extend/m-p/101867#M48728</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2021-03-24T16:06:27Z</dc:date>
    </item>
  </channel>
</rss>

