Client Access ODBC Optimization

[Cyndi Bradberry <CyndiB@xxxxxxxx>]

Everyone,

For reasons beyond my control, we are web-serving from an NT box using
Microsoft IIS. Our web applications (.asp using VBScript) use Client Access
ODBC to reach back to the AS/400 where all our data resides.  We have one
application in particular that accesses 17 different files. Eight files are
update; the other nine are validation table files which are used for
pull-down menus on our web application. We tried a time test by replicating
the table files on our SQL server and checking how long it took to load from
each source. SQL server won by several seconds in each test.  Multiplying
that out by 9 files.....it makes a big difference to people coming in over
the internet on a slow connection.  Anyway, corporate policy says that data
resides on the AS/400, we just get to it in different ways. So we have to
come up with methods to make the record retrieval faster.

My Questions:
Is there a way to make the ODBC connection faster ? 

Is there some other ODBC client that we should try ?

TIA,
Cyndi Bradberry
IHFA
Boise, ID

application/ms-tnef