I have several database access classes that prepare SQSL statements using the ODBCCommand object. Whenever the client needs data, these prepared command objects are executed using an OdbcDataAdapter to fill a DataSet. I can execute the same ODBCCommand over and over again, sometimes it works, sometimes it does not and it never happens at the same time. On error I get is "Service already in progress" on the line of code that uses the ODBCDataAdapter to fill a data set. Sometimes I get an error "The connection is dead."
Can anyone help???????