Post reply

Powershell using ODBC; putting CommandTimeout parameter into statements

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

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

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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply