I followed the instructions in this kb: https://www.paessler.com/en/topic/2053-how-can-i-monitor-other-sql-servers-through-ado-with-prtg

I downloaded the script and modified it for our environment. I then ran the script and it returned the number of items correctly with no issues. But when I add the custom sensor that uses this powershell script I just get "Could Not Establish Connection." I even tried it in a bat file and get the same result(works on desktop where PRTG is installed but doesn't work inside PRTG.) Any help would be greatly appreciated!!!!

Article Comments

Attention: This article is a record of a conversation with the Paessler support team. The information in this conversation is not updated to preserve the historical record. As a result, some of the information or recommendations in this conversation might be out of date.

The ADO sensor is already included "out of the box," within PRTG. Please try using the ADO sensor available within PRTG, seeing as the code has changed since.


Nov, 2012 - Permalink

When we use the default ADO sensor we get this error message:

"[Sybase][ODBC Driver]Could not load code page for requested charset"


Nov, 2012 - Permalink

Please have a look at http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc20155.1500/html/newfesd/CIHGEGFI.htm


Nov, 2012 - Permalink

Set to client on DSN settings and still getting exact same error message


Nov, 2012 - Permalink

This does not seem to be an issue within PRTG; please consult with your DB/SYS-Admin.


Dec, 2012 - Permalink