topic Qlik ODBC MSSQL error in Connectivity & Data Prep

Qlik ODBC MSSQL error

rbecher — Tue, 05 Dec 2017 10:20:06 GMT

Hi,

I'm trying to connect from Qlik Sense Desktop to a local instance of MSSQL with the Qlik ODBC connector and getting:

Error[08S01][Simba]Connection broken

Connecting via OLEDB works seamless..

With OLEDB:

Any idea what this error means? Any workaround?

- Ralf

Quy_Nguyen — Wed, 13 Dec 2017 12:41:18 GMT

Hi Ralf,

I have the same issue. Did you solve it?

rbecher — Wed, 13 Dec 2017 16:52:12 GMT

No, I use OLEDB connection now.

Quy_Nguyen — Thu, 14 Dec 2017 01:46:44 GMT

Is this a bug? Because OLEDB works well with the same configuration.

rbecher — Thu, 14 Dec 2017 17:04:06 GMT

I think so..

haawkie12 — Mon, 08 Jan 2018 13:23:52 GMT

Hi, same here... OLEDB works but you have to change all connections on current dashboards when you upgrade to the november version.

edvapran — Mon, 27 Aug 2018 11:16:10 GMT

We had the same problem, one day out of nowhere it stopped working.

Turned out that 1433 port to the sql server database was blocked.

After whitelist'ing the port it all started working again.

You can tell if port is blocked by using telnet command (an error will appear):

telnet <server name to the sql server> 1433