Hi. I am getting the following error
"The timeout period expired prior to completion of the operation or the server is not responding"
when I run the following code on view or table that has three million records.
Is there any way to extend the time before this errors out?
sSQL = "SELECT Count(*) As MyCount FROM (" & oSQL & ") As X"
Dim cn As New SqlConnection(oConnectionString)
Dim cmd As New SqlCommand(sSQL, cn)
Count_Rows_of_Query = cmd.ExecuteScalar.ToString
If cn.State <> ConnectionState.Closed Then