Your problem could be that you should force 32 bit...?
When Qlikview tries to connect using 64 bit and your odbc is configured 32 bit, it won't work...
Did you try that checkbox?
I'll checked my local sql 2012, and was able to connect over ODBC.. Make sure your SQL Browser service is started and tcp/ip connection is allowed (probably configured OK since you can reach SQL from other applications...)
Hello Henrik - if you are using the drivers that come with Expressor - you should be able to connect without issue. I believe the problem may be the protocols that are enabled on the MS SQL Server. When I installed MS SQL 2012 - I needeed to enable TCP/IP in the SQL Server Configuration Manager in order to get the provided drivers to work.
Programs ->MS SQL->Configuration Tools->SQL Server Confirgutaiton Manager
By default TCP/IP was not enabled. Also check your TCP/IP Dynamic ports - make sur the property is blank and does not have a 0 as a value.
Let me know how you do.
Sr. Product Marketing Manager
Anyone connected to SQL Azure? It works from the DSN however only the user DSN appears for me not ideal when we have different developers creating connections from the live schedule user? see no ability to use a System DSN? The supplied driver method 'Microsoft SQL server' connection fails with a "SQLSTATE:[08S01], Code:, Msg:[QVExpressor][ODBC SQL Server Wire Protocol driver]Socket closed."