I have worked for several years with QlikView, ans have some apps working great.
My employer wants to go to Qlik Sense, so I'm learning it.
My first problem is when I try to make a connection in Qlik Sense, the connection fail.
I'm using "Microsoft OLE DB Provider for SQL Server".
In Qlikview with the same configuration and same credentials it's working fine.
The db admin said to me that the logs say that the credentials are not valid.
I can not figure out what is going wrong, does anybody has an idea ?
I solved my problem in a different way : using Qlik ODBC Connector Package
I use same credentials and it created the connection.
(still don't know why OLE DB work in QlikView and not in Qlik Sense)
Thanks for your time.
Hi have you tried just Qlik embedded drivers.
Step 1 create new app
Step 2 select the 'Add data from files and other sources' button
Step 3 select Microsoft Sql Server (as in image)
Step 4 put connection details in. You will need the user to have at least read access to the database you connect to
yes it s working this way.
but I would like to have a connection in script mode.
To explain my needs :
I work for a SaaS application editor, all QV applications are accessed through this application (using web tickets).
I also have QV applications for generating QVDs.
Now I installed Qlik Sense server, and I try to make apps with Qlik Sense Desktop, for distribute them in the same way.