Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

MVP
MVP

Qlik ODBC MSSQL error

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

Tags (2)
6 Replies
Quy_Nguyen
Contributor III

Re: Qlik ODBC MSSQL error

Hi Ralf,

I have the same issue. Did you solve it?

MVP
MVP

Re: Qlik ODBC MSSQL error

No, I use OLEDB connection now.

Quy_Nguyen
Contributor III

Re: Qlik ODBC MSSQL error

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

MVP
MVP

Re: Qlik ODBC MSSQL error

I think so..

Highlighted
haawkie12
New Contributor

Re: Qlik ODBC MSSQL error

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

edvapran
New Contributor II

Re: Qlik ODBC MSSQL error

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

Community Browser