Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Quy_Nguyen
Specialist
Specialist

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

12 Replies
tomovangel
Partner - Specialist
Partner - Specialist

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
Specialist
Specialist
Author

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.

Chanty4u
MVP
MVP

Use OLEDB   for this

and directly add the connection

Quy_Nguyen
Specialist
Specialist
Author

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

Chanty4u
MVP
MVP

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
Specialist
Specialist
Author

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?

Quy_Nguyen
Specialist
Specialist
Author

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.

Chanty4u
MVP
MVP

why you are not using  OLEDB ?