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

32
 
 

Still if you are facing the issue, please see blow resolution:
Root Cause
-------------------------------------------------------------------
The issue which we were seeing on Windows 7 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.

Solution
-------------------------------------------------------------------
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 “http://support.microsoft.com/kb/935400”
My System SpecsSystem Spec
Reply

 ODBC connection problem





Thread Tools



Similar help and support threads for2: ODBC connection problem
Thread Forum
ODBC Setup Problem Microsoft Office
odbc connection win7 pro to unix Network & Sharing
how to establish a ODBC connection in Windows 7 64 bit ? Network & Sharing
ODBC Configuration General Discussion
odbc Software
ODBC Setup Problem Network & Sharing
problem about postgresql ODBC driver installation on W7 Drivers

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 07:44 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33