Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excessive database access time?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excessive database access time?
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Excel Database via Access Main Database with a script | New Users to Excel | |||
Access Database | Excel Discussion (Misc queries) | |||
Database Access | Excel Programming | |||
excessive rows when scrolling down | Excel Worksheet Functions | |||
Excessive time loading/saving file | Excel Programming |