Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
2. Using Qlik ODBC connector, i can not connect to the server with the same information.
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
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
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.
Use OLEDB for this
and directly add the connection
Yes, problem can be solved by OLE DB. But in case I want to use Qlik ODBC, what i have to do?
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?
Hi,
Could you please guide me how to check it? Here my ODBC 64bit:
In System DSN Tab, when i click Add, it doesnt show Qlik-mssql
Is there any thing wrong?
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:
I already updated to June 2018 but still got the same error.
why you are not using OLEDB ?