(Query in text form:
select pid,query,wait_event,state,* from pg_stat_activity;)
My connections are created this way (here in VBA):
Dim cnDB As New ADODB.Connection cnDB.Open "PostgreSQLDsnHere"
Where that DSN is created by:
- for 32 bit: go here:
- for 64 bit: go here:
- Go to the System DSN tab and enter the information (Data Source, Database,Server IP, User Name, Password, Port)
I could not figure out how to add the
application_name in this context/connection setup (using a DSN).
I tried adding this in various places in my VBA code, but it didn't work:
cnDB.Properties("ApplicationName") = "testing"
Where do I enter/set the
I know I can set the setting if I use a standard plain text connection string, but I cannot do that for security reasons. I have to use a DSN.
Non-VBA answers very welcome!