+ Reply to Thread
Results 1 to 2 of 2

Excessive database access time?

  1. #1

    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. #2

    Re: 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1