Re: Client Access ODBC

The first thing to do when dealing with an ODBC performance issue is to
make sure you're using the latest service pack for the most recent version
of Client Access;  tremendous improvements have been made in the last
several years.  For information on what the latest service pack levels are,
look at the following web page:

http://www.as400.ibm.com/clientaccess/casp.htm

You'll also find a number of tips related to performance tuning of ODBC on
the following two sites:

http://www.as400.ibm.com/developer/client/index.html
http://www.as400.ibm.com/clientaccess/cadev.htm

Hopefully some of that information will help!

Janet Krueger
D H Andrews Group





"Jeff Carey" <jeff_carey@baxter.com> on 03/23/2000 04:41:08 PM

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Janet Krueger/dhagroup/US)
Subject:  Client Access ODBC




We are having trouble with a web server using Client Access ODBC.
Currently the performance is much slower than calls using the same
interface to Oracle.  Also, occasionally the whole server stops wit a
dialog box from Client Access referencing COMM RC=0x17.   We are using
Client Access V3R2.  I suggested trying to run the Client Access ODBC
driver as a service under NT.  Any other suggestions?  Would we have
better results with Client Access Express?



+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com
+---






+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---