I have a .net 4.7 web application that reads data from a SQL Server database located on the same server. I run into the following .net error when trying to read a certain set of records from the database: The timeout period elapsed prior to completion of the operation or the server is not responding.
This isn't a connection error, because I can read a different set of records from the same page in my web application. If I point my web application to a copy of the same database and attempt to read the records that were causing the error, the page generates without error and returns the records without error, so I believe I can eliminate the data as the cause of the error.
So, if I'm not having a connection error to the SQL server or the database, and I'm not having a data error....what other things could be causing the timeout error?
Specifically, the error is happening in the code when I fill a dataset using the .net DataAdapter.fill procedure, and at the SQL client.tdsparser.try run procedure. At this point in the code, it throws an exception error.
EDIT: I found the answer to my error...see my comment below.