Shamil Salakhetdinov
shamil at smsconsulting.spb.ru
Fri Oct 29 04:05:14 CDT 2010
Hi All -- After several hours (~6 hours Win7 64bit, ~24hours WinXP) of running multi-threaded (.NET Framework 3.5 SP1 WinForms) desktop application using .mdb files as backend I'm getting the following runtime error: Exception -> Unspecified error StackTrace -> at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOption s options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbCon nection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at NetworkManager.SearchInputFileHandler.GetInputRows(SearchProgramTypeEnumerat ion programType, Int32 startRowNum, Int32 rowsQty, Boolean setupInProgress, Boolean filterOutUninitializedRows) It looks like this is an OleDbProvider bug. Have you seen/experienced something like that? Context: 1. I do exclusively use using (OleDbConnection cnn = new OleDbConnection("{{mymdbConnectionStringHere}}")) { cnn.Open(); ... } 2. I do use IN clause in some select SQL expressions to point to external MDB tables. I guess the issues is caused by case (2). Although that's still a hypothesis here to check (some code fixes are needed in the core code of my application, and I'm considreing now will that be worth fixing, or I should better switch to MS SQL backend.) Thank you. -- Shamil