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: 247158

  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.

  ---

• 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.