Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Quy_Nguyen
Contributor III

QlikSense connect to Microsoft SQL Server

Hello,

I want to create connection to my MS SQL Server.

1. Using OLE DB Provider for SQL Server, i can create the connection and read the data.

ole.PNG

2. Using Qlik ODBC connector, i can not connect to the server with the same information.

odbc.PNG error.PNG

It happens on both Qlik Sense Desktop and Enterprise. I am using April 2018 version and Qlik ODBC Connector package version 4.8.

Do i have to change any input/configuration to use Qlik ODBC connector?

Thanks,

Quy

11 Replies
tomovangel
Contributor III

Re: QlikSense connect to Microsoft SQL Server

I had faced the problem before, and in the end decided to use the OLE DB Provider for SQL.

I can't remember, but have you tried entering the IP address of the server? in the Server instance(where you have written .\sqlexpress) ?


And Im not sure, but you can check if you server has SPN and if not, you can try to configure 1 and then use it to connect with it?

BR,
Ace

Quy_Nguyen
Contributor III

Re: QlikSense connect to Microsoft SQL Server

Hi Ace,

It is MS SQL Server Express on my PC. I also try:

+ quynguyen\sqlexpress

+ localhost\sqlexpress

+ 127.0.0.1\sqlexpress

+ .\sqlexpress

All above work fine with OLE DB connector, but non of them work with Qlik ODBC connector.

sureshqv
Esteemed Contributor III

Re: QlikSense connect to Microsoft SQL Server

Use OLEDB   for this

and directly add the connection

Quy_Nguyen
Contributor III

Re: QlikSense connect to Microsoft SQL Server

Yes, problem can be solved by OLE DB. But in case I want to use Qlik ODBC, what i have to do?

sureshqv
Esteemed Contributor III

Re: QlikSense connect to Microsoft SQL Server

Did you check that the odbc driver is installed on system?

Did you define the odbc connection to the sql server database on his system?

Quy_Nguyen
Contributor III

Re: QlikSense connect to Microsoft SQL Server

Hi,

Could you please guide me how to check it? Here my ODBC 64bit:

bt.PNG

In System DSN Tab, when i click Add, it doesnt show Qlik-mssql

bt.PNG

Is there any thing wrong?

sureshqv
Esteemed Contributor III

Re: QlikSense connect to Microsoft SQL Server

Quy_Nguyen
Contributor III

Re: QlikSense connect to Microsoft SQL Server

Sorry but i can not figure out the solution from 2 posts  above.

If we create an ODBC data source in System DNS, we will use it by ODBC connector in Qlik Sense.

I mean that i want to use Qlik ODBC connector for  MS SQL Server.

The 1st one, not the 2nd one in picture below:

bt.PNG

I already updated to June 2018 but still got the same error.

sureshqv
Esteemed Contributor III

Re: QlikSense connect to Microsoft SQL Server

why you are not using  OLEDB ?

Community Browser