By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,139 Members | 1,228 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,139 IT Pros & Developers. It's quick & easy.

ODBC Linking

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 16 Aug 2004 02:21:56 -0700, si****@edmr.co.uk (Simon Bitchenor) wrote:
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?


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.
Nov 13 '05 #2

P: n/a
si****@edmr.co.uk (Simon Bitchenor) wrote in message news:<37*************************@posting.google.c om>...
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?


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
'---------------
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.