Simon wrote: > This is usually a kind of name resolution error. Check your DNS and host > files for proper name resolution.
I checked name resolution and ping turn around times. Response time of DNS and ping is <10ms. Robert wrote: > How did you measure the 1 second? If it was done with a different > tool than Access it may be that Access needs five seconds to process > the result (and probably do other stuff as well). For example if it > has to update a complex UI or such. > > If Access would do a connect per select than that would explain a lot, too. The measure was done by the SQL-Trace of the MAX-DB-ODBC Driver. I can see DISCONNECTS between each during the 5 second pause time. Can I get rid off these DISCONNECTs ? Regards, Dirk -- Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko! Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
