![]() |
|
13 Jun 2010 | #1 |
|
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 Specs![]() |
. |
|
03 Apr 2011 | #2 |
|
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 Specs![]() |
27 Nov 2011 | #3 |
|
the odbc connection can not occurs in my system.
|
My System Specs![]() |
. |
|
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. 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 Specs![]() |
![]() |
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 20:17. |
![]() ![]() ![]() ![]() ![]() |