Hi Ian,

The standard ODBC driver that ships with MPE if fine for doing simple
extracts but for doing serious querying, linking multiple tables with inner
& outer joins etc. it simply isn't good enough for the job.

I work for CSL in the UK we have specialised in middleware tools for MPE
users since the early 90's. Linkway Connect, our ODBC driver is widely
recognised as the fastest and securest driver on the market. Linkway will
handle everything you talked about, you can kill sessions that are using to
much CPU power and it will work perfectly for your ASP project.

I can supply a 30 day evaluation if you send me the system details I require
to send a license key for the downloadable version of Linkway Connect. The
details I need are available at an MPE Prompt after saying 'HELLO' on the
target HP 3000:-

:SHOWVAR HPSUSAN

:SHOWVAR HPCPUNAME

:SHOWVAR HPUSERLIMIT

I hope this helps.

David Taylor
Computing Solutions Limited
Tel: +44 (0)1905 794400

"Ian Fleming" <[log in to unmask]> wrote in message
news:xh_H7.167679$3d2.6764811@bgtnsc06-news.ops.worldnet.att.net...
> Hello MPE gods,
>
>   I recently adopted an HP 3000 running MPE/ix 6.5.  I have a read only
ODBC
> connector to an Image database that runs extremely slow (up to five
minutes)
> when running queries on Access 2000.  The actual data that I request
amounts
> to less than 100K characters.  If I link more than three tables in a
query,
> I consistantly get an ODBC timeout.
>
>   How do I manage the ODBC server on MPE?  Is there a way to terminate
open
> ODBC sessions?  How about monitor the load of the server?  I am really a
> *nix guy, a newbie to MPE.
>
>   I am about to construct an ASP script to retrieve data over an IIS
server
> but I am afraid of excessive wait time and timeouts if I cannot resolve
this
> problem.
>
> Thanks.
>
> Ian Fleming
>
>

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *