Re: Informix+ODBC+ADO.NET - problem

From: Plausible Indirection (cg22165_at_yahoo.com)
Date: 09/30/04 

Date: 30 Sep 2004 09:44:23 -0700

Marek,

It is hard for me to imagine why any problem with a select query would
cause a connection to go dead. I'm wondering if some problem between
the ODBC driver and your application is assuming that whatever went
wrong was the same as a dead connection.

There are some layers that could be peeled away. The ODBC driver
talks to the server; the (I'm assuming) Microsoft .Net Provider for
.Net, talks to the driver; I can't tell what might be above the .Net
provider (and, technically, there is the ODBC driver manager between
the Microsoft provider and the driver). You mention that the same
query runs when using something other than WinSQL; is that something
using the ODBC driver or is it something like Informix DBAccess? It
could be interesting to run the same query through ODBC Test (comes
with MDAC, in the samples).

However, that driver is pretty old. I'd try downloading and using the
latest CSDK (http://www.ibm.com/software/data/informix/downloads.html)
before spending too much time on problem isolation. Also, depending
on your needs, you may find the IBM Informix .Net provider that now
comes with the Client SDK a better solution than the ODBC bridge.

Luck,

Chris

"Mad One" <madonehc@NO-SPAM-PLEASE.poczta.onet.pl> wrote in message news:<uFgt1XtpEHA.3520@TK2MSFTNGP11.phx.gbl>...
> Hi!
> I'm developing an application using informix DBMS and .Net. I came across
> following problem, when I form a query with too many clauses in WHERE part
> and try to execute it with Fill command I get an exception "Connection is
> dead". Removing one of the clauses creates no problem at all. I have
> Informix ODBC drivers ver. 3.33, before that version exception was "Error -
> no info..". It isn't DBMS problem, because when I'm using non WinSQL with
> the same query everything works fine.
>
> //An example of a query, creating the problem:
> SELECT k.winien AS konto, SUM(wartosc) AS wartosc_wn, 0 AS wartosc_ma ,
> SUM(wartosc_w_walucie) AS wartosc_wn_wal, 0 AS wartosc_ma_wal, waluta AS
> waluta
> FROM ksiega_bis04 k
> WHERE (k.d_dekretacji < 'A4/01/31' ) AND (k.d_dekretacji >= 'A4/01/01' )
> AND (k.winien > '') AND ( stan = '0' ) AND (k.winien BETWEEN '201' AND
> '202') GROUP BY winien, waluta
>
> Thx in advance
> Marek Aleksander Dabek

Relevant Pages

  • Re: MS Access looks for .mdb rather than Progress schema
    ... It got past looking for pub.mdb, and looks like it tried to run the query ... I also tried putting the whole thing in the connection string: ... The settings for the Merant ODBC driver for ... default connect string means a jet database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: TOMCAT REALM dosnt work after DB was down
    ... > a new connection and try again. ... query to verify the connection and drop dead ones? ... isAliveQuery = Select * From Dual ...
    (comp.lang.java.databases)
  • Re: ASP - FROM statement slows down connection to database
    ... Open your database in Access, switch to the Queries tab, create a new query ... in Design View without choosing a table, swtich to SQL View, paste the sql ... connection string rather than using an ... recordset open statements. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Update checking
    ... My thought was to use a simple query with a "username" param ... concurrency exceptions happen if the data you queried has ... > was and basically let the user work in a similar offline mode. ... Where does connection pooling come ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... # Same query previously worked in Progress 8.x using SQL89. ... This entry allows you to keep your existing code written with the ODBC ... BTW, if you put all of the connect information into the connect string, ... I also tried putting the whole thing in the connection string: ...
    (microsoft.public.access.modulesdaovba)