Re: Qlik ODBC MSSQL error - Qlik Community

rbecher · ‎2017-12-05

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

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Quy_Nguyen · ‎2017-12-13

Hi Ralf,

I have the same issue. Did you solve it?

rbecher · ‎2017-12-13

No, I use OLEDB connection now.

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

Quy_Nguyen · ‎2017-12-13

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

rbecher · ‎2017-12-14

I think so..

Data & AI Engineer at Orionbelt.ai - a GenAI Semantic Layer Venture, Inventor of Astrato Engine

haawkie12 · ‎2018-01-08

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

edvapran · ‎2018-08-27

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