ODBC Linking

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Simon Bitchenor
    #1

    ODBC Linking

    I am linking an Access 97 front-end database to an ODBC data source
    (Sage Line 50 Version 9). Running the link on a Windows 98 PC the
    performance of the linked table is instant. Running under windows XP
    Professional the response increases to around 20-30 seconds. I have
    compared the ODBC settings on both operating systems and they seem
    identical. The windows XP PCs are all Celerons 2.0Ghz+ with 512Mb RAM,
    the windows 98 PC is a 1Ghz AMD Athlon with 512Gbytes RAM. Any
    suggestions on why there is such a big performance difference?
    Tags: None
    • Steve Jorgensen
      #2
      Re: ODBC Linking

      On 16 Aug 2004 02:21:56 -0700, simonb@edmr.co. uk (Simon Bitchenor) wrote:
      [color=blue]
      >I am linking an Access 97 front-end database to an ODBC data source
      >(Sage Line 50 Version 9). Running the link on a Windows 98 PC the
      >performance of the linked table is instant. Running under windows XP
      >Professional the response increases to around 20-30 seconds. I have
      >compared the ODBC settings on both operating systems and they seem
      >identical. The windows XP PCs are all Celerons 2.0Ghz+ with 512Mb RAM,
      >the windows 98 PC is a 1Ghz AMD Athlon with 512Gbytes RAM. Any
      >suggestions on why there is such a big performance difference?[/color]

      I've seen this happen with MS SQL Server if the Windows machine has its DNS
      settings pointing to an external DNS server. Windows tries to resolve the
      name of the server using TCP/IP name resolution first (HOSTS file, then DNS
      lookup), then tries SMB name resolution (LMHOSTS file, WINS, NETBIOS).

      Make sure whatever the system's primarty TCP name resolution mechanism is, it
      will be able to resolve the IP address of the SQL Server. If your only DNS
      server is external, that will mean adding an entry to the HOSTS file on each
      system.

        Comment

        • almish
          #3
          Re: ODBC Linking

          simonb@edmr.co. uk (Simon Bitchenor) wrote in message news:<374de02.0 408160121.1743f 8a6@posting.goo gle.com>...[color=blue]
          > I am linking an Access 97 front-end database to an ODBC data source
          > (Sage Line 50 Version 9). Running the link on a Windows 98 PC the
          > performance of the linked table is instant. Running under windows XP
          > Professional the response increases to around 20-30 seconds. I have
          > compared the ODBC settings on both operating systems and they seem
          > identical. The windows XP PCs are all Celerons 2.0Ghz+ with 512Mb RAM,
          > the windows 98 PC is a 1Ghz AMD Athlon with 512Gbytes RAM. Any
          > suggestions on why there is such a big performance difference?[/color]

          I've heard that XP sp 2 has a fix for this type of problem. I can't
          find the MSKB article on it right now... I haven't tried it and
          probably won't until the dust settles...

          '---------------
          ' John Mishefske
          '---------------

            Comment

            Previous template Next
            Working...