Any way of sending "Application Name=MyAppName;" string for the ODBC connection

[mellerbeck]

This would be useful to be able to see on the server which Qlikview is using resources etc...

[Jason_Michaelides]

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

[mellerbeck]

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?

[#4]

i don't think you can do that with ODBC. You can with OLE DB.

[Jason_Michaelides]

That's just part of the second half of the conmection string.

[Jason_Michaelides]

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.

[mellerbeck]

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?

[Jason_Michaelides]

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.

[mellerbeck]

Thanks Jason! Would love to see your examples!