December 16, 2021 at 10:28 pm
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 12:35 pm
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy