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