Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
alexandra_dh
Contributor III
Contributor III

Qlikview - Wizard for select database uses wrong datasource

Hi everybody,

I have a problem in Qlikview with using the wizard to select my DataSource.

I have generated a list of OLEDB Connection (based on SQL Server or Oracle database) . I want to give to my Qlikview users these generated connection (they doesn't know user/pwd that are used so they can't generate themseves their connexion).

All is ok by their side, the connexion is OK.

if they make a LOAD whith an known table it's OK too.

An exemple :

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=Qlik_Sid_Ssa;Data Source=10.10.10.10,1433] (XPassword is XXXXXX);

TEMPS:

LOAD * ;

SQL SELECT *

FROM DWH.dbo."DIM_TMPS_DATE";

But if they want to use the wizard to select their tables, the fields ....  the window "Data Link Properties" opens and they have to recreate the connection (and they can't ....)

The previous connection is not recognize ....

We use Qlikview 12.10.20400 SR6

Thanks for your help

0 Replies