Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
simotrab
Creator III
Creator III

Qlik Sense Desktop error in OLE DB and ODBC

Good morning,

I have a problem with Qlik Sense Desktop: I cannot have any connections using OLE DB and ODBC.

Using OLE DB I cannot have the connection. I decided to avoid the problem creating an ODBC: I can create it, so the problem is not the ODBC itself, but when I try to create a connection in Qlik the problem is listed as

error of connection to the connector: {0}   (translated from my language).

I am using Qlik Sense 3.2 SR1, with WINDOWS 10.

I really need an help.

Thanks in advance

UPDATE:

Here some screenshots: OLE DB error, ODBC error and the driver I use for the ODBC.

OLE DB ERROR

oledb.PNG

ODBC ERROR

odbc.PNG

DRIVER

driverodbc.PNGdriverodbc2.PNGdriverodbc3.PNG

6 Replies
marcos_herrera
Partner
Partner

Hi Dear Simone

How are you creating the Ole DB or ODBC? Are using generic driver, Qlik ODBC package or Database maker driver?

petter
Partner
Partner

Can you share a screenshot?

simotrab
Creator III
Creator III
Author

Hi, thanks for your answer!

I'm using for the ODBC the SQL Server driver.

For the OLE DB I'm using the wizard of Qlik Sense Desktop.

Hope it helps.

marcos_herrera
Partner
Partner

On the ODBC option are you using Microsoft Native ODBC and in OLE DB are you using Microsoft SQL? Server OLE DB? If this is correct Please Try to connect with the same driver, but from MS Excel

simotrab
Creator III
Creator III
Author

Updated the question with some -hoping- useful pics of the driver.

Thanks again!

simotrab
Creator III
Creator III
Author

Sorry for the waiting,

I have updated the question with pics.

Thanks a lot!