<div>
Sometimes I fine that OleDb works better.
</div>


Sometimes I fine that OleDb works better.

<div>
What type of database are you connecting to? <br />
<br />
Bob
</div>


What type of database are you connecting to?

Bob

<div>
Bob,<br />
<br />
We are using an Informix 9.X database.
</div>


Bob,

We are using an Informix 9.X database.

<div>
My suggestion would be to use a managed .NET provider to connect to Informix, versus using ODBC. &nbsp;You will be much happier with the performance.<br />
<br />
OpenLink Software:<br />
<a href="http://uda.openlinksw.com/ado.net/mt/dotnet-informix-mt/" rel="ugc">http://uda.openlinksw.com/ado.net/mt/dotnet-informix-mt/</a><br />
<br />
Bob
</div>


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/ [http://uda.openlinksw.com/ado.net/mt/dotnet-informix-mt/]

Bob

<div>
The solution wound up being to check a check box under the advanced options of the odbc driver in question to &quot;Open-Fetch-Close Optimization&quot;. &nbsp;I still do not understand why this has appeared to fix the problem.
</div>


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.

<div>
<div class="content wysiwyg-content">
I have several database access classes that prepare SQSL statements using the ODBCCommand object. &nbsp;Whenever the client needs data, these prepared command objects are executed using an OdbcDataAdapter to fill a DataSet. &nbsp;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. &nbsp;On error I get is &quot;Service already in progress&quot; on the line of code that uses the ODBCDataAdapter to fill a data set. &nbsp;Sometimes I get an error &quot;The connection is dead.&quot;<br />
<br />
Can anyone help???????
</div>
</div>


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???????

ADO.NET Errors

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.