Excessive database access time?

[jd_12345]

Windows XP Pro SP2
Excel 2003 SP2
IBM DB2 Personal Edition accessing a DB2 database on an AIX server via
ODBC

I am accessing an external DB via Data-->Import External Data -->New
Database Query. Last week I connected quickly and reliably. As of
Monday morning, It now takes 7.5 minutes to connect to the DB and all
the while the hard disk is spinning constantly. Another application no
longer connects at all with the following message, "[IBM][CLI Driver]
SQL1336N The remote host "dbt_rpts" was not found.".

Has anyone experienced such a degradation in access time and have an
idea for a fix?

Thanks, Jim D.

 

[jd_12345]

I found that Norton Internet Security was interfering with the DB
connectivity. All tools now connect reliably but MS Excel still is
very slow when originally it wasn't

Jim D.