Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: ODBC connection problem

13 Jun 2010   #1

Windows 7
ODBC connection problem

I'm running 2005 SQL server on Windows 2008 server. I have both Windows 7 and XP ODBC connections to the server. Everything was working fine but the server was running slow so I tried a windows update. The update made my ODBC connection go flakey, but only on Windows 7. Testing the connection would be successful, for several tests, then fail and you would have to reboot the workstation. I have both SQL server and Native Client. Now I am unable to create a connection with either. I've uninstalled the updates which hasn't helped. It seems like the update changed a security setting somewhere. Creating a new connection now fails with SQL state 08001 and server error 10060

Regards Hakit

I have the system working now with both Win 7 and XP Pro but not really happy with the fix. The SQL passwords seem to be stored in a different encryption for these 2 OS's If I change the password on the SQL server then let Win 7 rebuild it the system works ,, but you can't use that login on XP Pro without doing the same thing over again.

My System SpecsSystem Spec
03 Apr 2011   #2

win7 ultimate x64
I am having the same issue

Hakit, does your workaround work for users with windows authentication?
IF so can you step me through your method for resetting ?
My System SpecsSystem Spec
27 Nov 2011   #3

windows 7 ultimate 32bit

the odbc connection can not occurs in my system.
My System SpecsSystem Spec

13 Feb 2012   #4


Still if you are facing the issue, please see blow resolution:
Root Cause
The issue which we were seeing on Win7 VDIs could be due to the Network hardware device connected with the machine. If TCP/IP scaling is not supported by the network device then the performance will be slow.

Disable auto tuning level of the TCP. Please follow below steps:
1) Open command Prompt with admin right (Run as Admin)
2) Type “netsh interface tcp set global autotuninglevel=disabled”
3) After running above command restart the machine.

For other information on this command, visit link “”
My System SpecsSystem Spec

 ODBC connection problem

Thread Tools

Similar help and support threads
Thread Forum
SQL Server ODBC Connection Mysterious Fails
Bonjour! We are moving an old Access project from XP too Windows 7 32 and .Net. However there is something wrong with Windows 7! When I try and create an ODBC link via ODBC Administrator to allow the software to access data tables on SQL Server on the Windows 2003 Server it just keeps...
Network & Sharing
Access & ODBC connection issue on W7 Home, State 11
I have two laptops at my company that have Windows 7 Home - thus cannot login to AD/Domain as a specific user. They in-turn use a local administrative account setup on those laptops. We have a database setup with linked connections to our SQL Server 2005. Whenever we're trying to access those...
Microsoft Office
ODBC Setup Problem
I have Win 7 Ultimate 64 bit. I have the following problem.. when I try to install an ODBC connection (*mdb), Data sources ODBC > SYSTEM DSN > ADD > (here only sql server is listd, not .mdb) and also I get the following fault message: "The Microsoft Access Driver (.mdb) ODBC driver could...
Microsoft Office
how to establish a ODBC connection in Windows 7 64 bit ?
Hello, I have created a ODBC connection between MS Acceess 2003 and Excel 2003 in Windows 7 32bit enviroment . The Macro ( code ) is as follows : ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access...
Network & Sharing
ODBC Setup Problem
I am sorry if this has been asked previously. I have Win 7 Ultimate 64 bit, which is an upgrade from Vista Business 64 bit. I have the following problem when trying to install an ODBC connection (*mdb). When I run odbcad32.exe, from the SysWOW64 directory, and try to install the 32 bit MS Access...
Network & Sharing

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 06:32.
Twitter Facebook Google+