Qlikview - Wizard for select database uses wrong datasource

alexandra_dh — Wed, 17 Oct 2018 09:48:34 GMT

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

topic Qlikview - Wizard for select database uses wrong datasource in QlikView

Qlikview - Wizard for select database uses wrong datasource