Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
This would be useful to be able to see on the server which Qlikview is using resources etc...
Sure:
LET vConnString = 'first part of connection string' & Documentname() & 'second part of connection string';
Then, whenever you need to connect:
CONNECT TO $(vConnString);
Hope this helps,
Jason
How does that work in conjuntion with the encrypted username / password.
i.e.
I have
ODBC CONNECT TO QVReports (XUserId is blahblah, XPassword is blahblah);
How to convert to vConnString?
i don't think you can do that with ODBC. You can with OLE DB.
That's just part of the second half of the conmection string.
Although Juan may be right...can't test right now and I can't remember if I used this before on ODBC or OLE DB.
Anyone have an example for me for how they do their connection strings? (best practices?) Do you store them in a file? Are you sending the Application Name=MyApp to help on the sql side of things. Do you prefer OLE DB versus ODBC?
I use a config .xls file with environments (servernames, document paths, connection strings etc) and all my QVWs have a config tab which loads from this spreadsheet into multiple variables. I can't post an example here just yet but will try to do so either tonight or tomorrow for you.
Thanks Jason! Would love to see your examples!