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 *