ADO.NET Errors

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???????
LVL 2
afpcosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

planoczCommented:
Sometimes I fine that OleDb works better.
Bob LearnedCommented:
What type of database are you connecting to?

Bob
afpcosAuthor Commented:
Bob,

We are using an Informix 9.X database.
Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Bob LearnedCommented:
My suggestion would be to use a managed .NET provider to connect to Informix, versus using ODBC.  You will be much happier with the performance.

OpenLink Software:
http://uda.openlinksw.com/ado.net/mt/dotnet-informix-mt/

Bob
afpcosAuthor Commented:
The solution wound up being to check a check box under the advanced options of the odbc driver in question to "Open-Fetch-Close Optimization".  I still do not understand why this has appeared to fix the problem.
moduloCommented:
PAQed with points refunded (500)

modulo
Community Support Moderator

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.