Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
simotrab
Not applicable

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
Not applicable

Re: Qlik Sense Desktop error in OLE DB and ODBC

Hi Dear Simone

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

petter
Not applicable

Re: Qlik Sense Desktop error in OLE DB and ODBC

Can you share a screenshot?

simotrab
Not applicable

Re: Qlik Sense Desktop error in OLE DB and ODBC

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
Not applicable

Re: Qlik Sense Desktop error in OLE DB and ODBC

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
Not applicable

Re: Qlik Sense Desktop error in OLE DB and ODBC

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

Thanks again!

simotrab
Not applicable

Re: Qlik Sense Desktop error in OLE DB and ODBC

Sorry for the waiting,

I have updated the question with pics.

Thanks a lot!