Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Don't know what happened but on my Windows 7 64bit the connection to SQL2005 using SQL Native client is not working anymore.

More in detail, if I try to connect to the SQL server using oledb it works fine, no matter is from VB.NET, UDL file, MS Access, ODBC etc etc

If I try the same (same user, same server, same database) using SQL Native client, it hangs. It hangs from a VB.net program, hangs from an UDL file, hangs from ODBC source etc

I tried many things without solving it. Is there a way to reinstall, fix, restore etc etc Sql Native client?

share|improve this question
    
Sure; Just reinstall it..microsoft.com/en-us/download/details.aspx?id=24793 –  Ramhound Mar 15 '14 at 23:12
    
thanks, but it didn't solve the issue, other suggestions? –  Corrado Mar 17 '14 at 9:44

1 Answer 1

Following helps me:

http://blogs.msdn.com/b/sql_protocols/archive/2010/08/13/windows-7-appcompat-changes-and-sql-server-client-and-setup-hangs.aspx

In article specified GPO setting "Turn off Switchback Compatibility Engine" under Computer Configuration\Policies\Administrative Templates\Windows Components\Application Compatibility must be set to Not Configured or Disabled! If this setting is set to Enabled, then SQL Server Native Client hangs.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.