Solarwinds SAM: ODBC User Experience Monitor PostgreSQL

tbgrp

Dear Thwack community,

I'm currently working on an ODBC User Experience Monitor Custom Check and I'm running crazy. I want to connect to a PostgreSQL database which is running on a Windows Server 2019 in Azure

We've created the following connection string:
Driver={PostgreSQL Unicode};Server=${IP};Port=5432;DataBase=<MYDB>;Uid=${USER};Pwd=${PASSWORD};

Now the following issue comes up:
If I run this connection string on a node which is not monitored by an agent it works properly. The application check is "up".

When im running this connection string on a node which is monitored by an agent it throws the following exception:
"Datasource name not found and no default driver specified".

I've already changed the setting to x86 & x64. I tried all combinations.

The issue is also not network or routing related.

I highly appreciate any tip!

Best regards

Tobias

Seashore

When you have an agent the check is done from the agent (I think) where the driver might not be installed. With Agentless its ran from the polling agent where I guess you have installed the odbc driver. Change the template not to use agent but be "agentless"