topic Re: Expressor SQL connection in QlikView

Expressor SQL connection

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

I'm trying to connect to a local SQL 2012 server, and I get the following error:

SQLSTATE:[08001], Code:[0], Msg:[expressor][ODBC SQL Server Wire Protocol driver]Connection refused. Verify Host Name and Port Number.

I have no problem connecting from Excel or SQL server Manager Studio.

The SQL server and Expressor is a local installation (on the same pc).

I have disconnected the firewall.

I works nicely when creating a ODBC DSN using the driver "SQL Server Native Client 11.0".

Could it be that the driver used in the drop down is "SQL Server"?

Best regards

Henrik

Re: Expressor SQL connection

Mon, 25 Jun 2012 09:16:20 GMT

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?

Edited

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...)

Re: Expressor SQL connection

Miguel_Angel_Baeyens — Mon, 25 Jun 2012 09:16:39 GMT

Hi Henrik,

Are drivers for 32 bits or 64 bits? Note that you will see different ODBC names in the dialog window when you click on the "Connect" button in the script editor, hence loading different DSN.

Hope that helps.

Miguel

Re: Expressor SQL connection

Anonymous — Mon, 25 Jun 2012 09:22:35 GMT

I don't have a 32/64 bit property in Expressor. It's not in QlikView.

This is my screendump:

Henrik

Re: Expressor SQL connection

Mon, 25 Jun 2012 09:25:15 GMT

Ok, that I cannot test; I assumed perhaps the 32/64 bit could have been a problem. Since I don't have Expressor here I cannot help (hopefully others can 🙂 )

Re: Expressor SQL connection

Michael_Tarallo — Mon, 25 Jun 2012 13:06:49 GMT

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.

Mike Tarallo

Sr. Product Marketing Manager

QlikView Expressor

Re: Expressor SQL connection

Anonymous — Mon, 25 Jun 2012 13:15:18 GMT

Thanks!

that works after restarting the SQL Server service.

Henrik

Re: Expressor SQL connection

Michael_Tarallo — Mon, 25 Jun 2012 16:03:12 GMT

Great to hear! - I have created a document out of this post - so others can benefit form the solution if they have the same problem. I also responded to your email with the license key. Let me know how you do.

Mike T

Re: Expressor SQL connection

sfr_qlik — Tue, 27 Aug 2013 09:17:28 GMT

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:[0], Msg:[QVExpressor][ODBC SQL Server Wire Protocol driver]Socket closed."