Slow ODBC Connection Issue

[seaport]

My Access database system is connected to the remote SQL Server 2005 Standard (in the same LAN) through ODBC DSN. The LAN is peer-to-peer. Most of client machines using Win XP and the DSN connection is fast. However, one Vista machine always had slow connection. When I clicked the button "Test Data Source" at the ODBC set up screen, it took about 10 seconds to show the result "TESTS COMPLETED SUCCESSFULLY."

I thought it was a Vista problem and upgraded the machine to Windows 7 Pro. But the problem persisted. I tried both SQL Server driver and SQL Server Native Client driver in DSN and got the same. In my last try, I entered the IP address of the SQL server to replace the SQL Server name in the DSN setup. It worked and the connection was instant.

Could someone help me figuring out why? If this is related to DNS, FYI that computer always "obtains DNS Server address automatically" in the network adapter setup.

Thanks in advance.

 

[kuekue]

i found look like this problem too, my co-worker tell me set config to TCP/IP, co-worker check not have problem with windowsXP but windows7 have it.

i check in config ODBC in windows XP it 'TCP/IP' (in client configuration of SQL Server Driver) and can choose windows authentication, but in Windows7 when i choose 'TCP/IP' i cannot pass windows authentication but can connect by username and password but i don't need it.

Can you try config to 'TCP/IP' ?

and check the time respond again.

 

[kuekue]

and i search from internet someone advise to connect by SQL native client, you should to try it.