I have a C# online application where users logon to the app. Currently, all users share the same single connection to the database, and I use C# threading. The problem this is causing is when a call or update takes extra time, it causes the datareader to fail. Such as the case when one person is downloading a file while someone else is trying to run a more simple select. See the activity log excerpt below:
>select * from vw_appl_doc where application_id = 709 and file_id = 70819
>SELECT * from appl_trans WHERE applicant_id=70948
>ExecuteReader requires an open and available Connection. The connection's current state is Open, Executing.
I am also getting other errors I believe due to the same issue. Such as:
ERROR  [Microsoft][ODBC Driver Manager] Connection in use
Is there something I can do to prohibit these issues? My database is ASA6. Overall my pages use DataReaders which I dump into DataTables. I have been very careful to close all opened datareaders after use.
Is there a way to solve these problems and keep a single database connection???
Thanks In Advance!!