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.
