ADO SQL sensor throws buffer error on Informix ODBC

Hi Stephan

I was able to solve it thanks to your quick answer. I was using the wrong provider (MSDASQL instead of IFXOLEDBC). Additionally, I thought it's be enough to provide only the system DSN name. Turns out, to use IFXOLEDBC you need to set additional parameters in your connection string according to the examples listed here: https://www.connectionstrings.com/ibm-informix-ole-db-provider.

Hi Silas,

Cool! Glad it's working now :)

Kind regards,
Stephan Linke, Tech Support Team

I can't get an ADO SQLv2 sensor to work with an Informix DB. We have an Informix DB running on a Linux Server. The sensor is setup with the connection string: Provider=Ifxoledbc;Data Source=xxxx@xxxxxxx;User ID=xxxxxx;Password=xxxxxx;. The IBM Informix Client SDK is installed on the core Server/local Probe. I get an Sensor error: Fehlercode: E_FAIL(0x80004005) How can i solve the Problem?

Do you get the same error while trying to run the sensor manually as mentioned by Stephan? It's located in the directory of the probe:

C:\Program Files (x86)\PRTG Network Monitor\Sensor System\SQLv2.exe

Kind regards,
Felix Saure, Tech Support Team

Which Information do I have to type in under the Settings:

• Type ->ADOSQL?
• Server ->Servername of the VM?
• Port ->?
• Database -> xxxx@xxxxx?
• Domain -> Our Domain
• Username -> xxxxxx
• Password -> xxxxxx

With these Information i get an error "Das Format der Initialisierungszeichenfolge stimmt nicht mit der Spezifikation überein, die bei Index '0' beginnt". Could you give me an example for the Information i need to fill in in the GUI. How can I check the DB Connection between the local probe and the Informix DB

Hello Georgi,

ADOSQL sensors require a connection string as described here. Does it work with this key:

Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=myUsername;
Password=myPassword;

Kind regards,
Felix Saure, Tech Support Team

Hello Felix Saure,

I used this string in the Sensor but i get an Sensor Error: Fehlercode: E_FAIL(0x80004005)

Hello,

E_FAIL(0x80004005) errors are related to machines running in a virtual box. Please copy the sensor folder to a not virtualized Windows machine and start the sensor from there:

Program Files (x86)\PRTG Network Monitor\Sensor System\

Does it connect correctly from there?

Kind regards,
Felix Saure, Tech Support Team

Hello,

I copied the Folder "Sensor System" to my local drive and installed IBM Informix Client SDK. When I run the SQLv2.exe I get the error: "No error message available, result code: E_FAIL(0x80004005)

Screenshot: https://www.dropbox.com/s/kxp5l5eegsmozk7/SQL_ibm_fehler.JPG?dl=0

Hello Georgi,

Could you please also try a different connection tool, like this one, to see if the connection works in general?

Kind regards,
Felix Saure, Tech Support Team