I can't get an ADO SQLv2 sensor to work with an Informix DB through ODBC on a Windows Server 2012. Tests through Windows odbcad32 work without any errors. The sensor ist setup with default settings and the connection string is a simple "Provider=MSDASQL;Dsn=_name_of_system_dsn;" This triggers the following driver error:

ERROR [HY000] [Informix][Informix ODBC Driver][Informix]Internal communications buffer management error detected

According to the IBM knowledgebase, this usually indicates faulty RAM. However, since the ODBC test on its own works, I suspect something's going wrong between prtg - msdasql provider - odbc?

Article Comments

Are you getting the very same error when using the actual EXE file, configured accordingly:
C:\Program Files (x86)\PRTG Network Monitor\Sensor System\SQLv2.exe

The IBM Informix Client SDK is installed as well? The provider to use would be Ifxoledbc.

Kind regards,
Stephan Linke, Tech Support Team


Dec, 2017 - Permalink

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.


Dec, 2017 - Permalink

Hi Silas,

Cool! Glad it's working now :)

Kind regards,
Stephan Linke, Tech Support Team


Dec, 2017 - Permalink

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?


Sep, 2018 - Permalink

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


Sep, 2018 - Permalink

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


Sep, 2018 - Permalink

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


Sep, 2018 - Permalink

Hello Felix Saure,

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


Sep, 2018 - Permalink

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


Sep, 2018 - Permalink

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


Oct, 2018 - Permalink

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


Oct, 2018 - Permalink