Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i need to connect to a Database and to do this i have used this statement:
OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=USER_ID;Data Source=DATA_SOURCE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=M_WS_ID;Use Encryption for Data=False;Tag with column collation when possible=False];
This cause the following error:
CONNECTs other than LIB CONNECT are not available in this script mode: OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=AAAAAAA;Data Source=XXXXXX;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=KKKKKKKI;Use Encryption for Data=False;Tag with column collation when possible=False]
Anybody knows how to solve this?
Thanks
1. Use the Qlik Sense UI to create a connection for you that gets added to the libarary
2. Perhaps you can use your 'qlikview' connect statement if you enable the Legacy mode. I'm not sure this works. I haven't tried that yet.
I have tried the ui to create the connection and i get this statement:
LIB CONNECT TO 'db';
the load statement that is generated is this:
LOAD A,
B,
C,
D,
E,
F,
G;
SQL SELECT A,
B,
C,
D,
E,
F,
G
FROM CATALOG.dbo.TABELLA;
but on qlikview i use this form that seems to not work under qliksense:
TABELLA:
SQL SELECT *
FROM $(M_GES_CAT).dbo.TABELLA;
I use also join expressions so is it possible to continue with the second form?
Thanks
That's correct. Dollar expansion of variables in load/select statements does not work unless you revert to Legacy mode.
How can i do to revert to legacy mode?
Thanks
See point 2 of my first post in this discussion.
Hi Marco,
This link will help you:
https://help.qlik.com/sense/1.1/en-US/online/Subsystems/Hub/Content/LoadData/DisableStandardMode.htm
G.