Hi All,

I cannot say anything about SE but I have doen some work with Impromptu and
ODBC.

Firstly I would recommend that you do not leave the TIMEOUTs at MAXIMUM as
this means that you will wait forever for another process to release a
lock! This setting does NOT relate to how long the query is being processed.

Impromptu does have configurable query timeout value, but it will only be
able to terminate a lengthy query if it is able to set the datasource to
asynchronous operation.

In this case I suspect that the comms routines on the PC got impatient
waiting for a message from the server!

<plug alert>

The LINKWAY ODBC driver allows for ASYNCHRONOUS connections

<end plug>

James J. Kanihan wrote:
>
>Hello MPE folks,
>
>I've just discovered this amazingly informative newsgroup, so I hope
>someone out there can help me.  So far, the HP Response Center sounds
>like they're mostly guessing, and they haven't been able to help.  I'm
>using Cognos Impromptu (version 4.01) to query an Allbase (version
>A.G1.21) database, and I'm using the 32-bit ODBCLink/SE driver
>(version E.55) under Windows NT Server 4.0, and MPE version 5.5.  If
>the query tries to return a large (approx. 1 million) number of
>records, it crashes with the error message "[ODBCLN32.DLL] Timeout on
>data read" after about 15 minutes.  Cognos says that this is not their
>message; it is being generated either by the database or ODBC driver.
>When this whole thing started, we were using the old HP PC API Allbase
>driver with Allbase version A.G1.14, and the error was slightly
>different; the database generated a "Column out of range" error
>immediately when the query was executed.  We tried the new ODBCLink/SE
>driver and updated our Allbase version as per the HP Response Center's
>suggestions, but we're still having problems.  In our SQLUTIL settings
>for the Allbase DBE we have MAXIMUM TIMEOUT set to NONE and DEFAULT
>TIMEOUT set to MAXIMUM.  On a DBE with the same structure but much
>less data, everything runs fine.  If anyone out there is still with
>me, I'd appreciate any insight you may have.
>
>Thanks in advance,
>
>Jim Kanihan
>[log in to unmask]
>
_______________________________________________________
Ken Vickers
LINKWAY Development and Support
Computing Solutions Limited
10 St Andrews Road
Droitwich, Worcestershire
UNITED KINGDOM
TEL +44 (0) 1905 794400
FAX +44 (0) 1905 794464
mailto:[log in to unmask] or
mailto:[log in to unmask]