Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

mellerbeck
Contributor II

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

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

8 Replies
jason_michaelid
Honored Contributor II

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

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
Contributor II

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

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?

Not applicable

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

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

jason_michaelid
Honored Contributor II

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

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

jason_michaelid
Honored Contributor II

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

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
Contributor II

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

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_michaelid
Honored Contributor II

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

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
Contributor II

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

Thanks Jason! Would love to see your examples!

Community Browser