Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

tdechiron
New Contributor III

OLEDB Sql Server problem with Qlik Sense

Hi,

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 ?

1 Solution

Accepted Solutions
tdechiron
New Contributor III

Re: OLEDB Sql Server problem with Qlik Sense

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.

12 Replies
agigliotti
Honored Contributor II

Re: OLEDB Sql Server problem with Qlik Sense

Are you using Qlik Sense Desktop ?

Which version ?

tdechiron
New Contributor III

Re: OLEDB Sql Server problem with Qlik Sense

yes version is november 2017

Khan_Mohammed
Honored Contributor II

Re: OLEDB Sql Server problem with Qlik Sense

Maybe use

OLE DB Provider for Microsoft Directory Services (32bit) ??

You cannot use Windows Integrated security instead of username and password to test the connection?

agigliotti
Honored Contributor II

Re: OLEDB Sql Server problem with Qlik Sense

did you try using "Windows integrated security" ?

tdechiron
New Contributor III

Re: OLEDB Sql Server problem with Qlik Sense

no because I can not do that, i must use username / password.

I tried all providers including 32bit without success

agigliotti
Honored Contributor II

Re: OLEDB Sql Server problem with Qlik Sense

let's try using the same driver and credentials with Qlikview Desktop on the same computer.

darrell_tobin
Contributor

Re: OLEDB Sql Server problem with Qlik Sense

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

sqlimgqlik.PNG

tdechiron
New Contributor III

Re: OLEDB Sql Server problem with Qlik Sense

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.

darrell_tobin
Contributor

Re: OLEDB Sql Server problem with Qlik Sense

1. Try to use the password to access database using SSMS  -Does this work.

If so then the account is correct.

2. Is account on a domain.  If so try adding domain to the account login name.

Community Browser