Powershell using ODBC; putting CommandTimeout parameter into statements

• doughora

  Old Hand

  Points: 321

  More actions

  December 16, 2021 at 10:28 pm

  #3964570

  I'd like to get the  CommandTimeout=0    into the command below before the   ExecuteReader  is done.

  I haven't found any examples with this type of code showing where to place the  CommandTimeout  parameter.

  Thanks for any help with this.

  ---------------------------------------------------

  $text = "A valid query string that was built"

  $conn = New-Object Data.Odbc.OdbcConnection

  $conn.ConnectionString= "DSN=QDSN"

  $conn.open()

  $result =(new-Object Data.Odbc.OdbcCommand($text,$conn)).ExecuteReader()

  $table = new-object "System.Data.DataTable"

  $table.Load($result)

• Phil Parkin

  SSC Guru

  Points: 246993

  More actions

  December 17, 2021 at 9:38 am

  #3964720

  Have a look at this link.

  In order to use CommandTimeout, it seems you will first need to create an OdbcCommand and push your query through that.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• doughora

  Old Hand

  Points: 321

  More actions

  December 17, 2021 at 12:35 pm

  #3964763

  Thanks.

  That got me in the right direction to put in similar code in a Powershell script and it now executes.

• December 17, 2021 at 5:10 pm

  This was removed by the editor as SPAM