ODBC connection problem


  1. hakit
    Posts : 1
    Windows 7
       New #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.
    Last edited by hakit; 18 Jun 2010 at 18:58. Reason: update
      My Computer
    Quote Quote

  3. damos
    Posts : 1
    win7 ultimate x64
       New #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 Computer
    Quote Quote

  4. pinaki
    Posts : 1
    windows 7 ultimate 32bit
       New #3

    the odbc connection can not occurs in my system.
      My Computer
    Quote Quote

  6. dreammunna
    Posts : 1
    32
       New #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 Computer
    Quote Quote

 

  Related Discussions
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...
ODBC Setup Problem
in Microsoft Office

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...
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...
ODBC Setup Problem
in Network & Sharing

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...
Our Sites
Site Links
About 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 01:03.
Find Us