I had updated .NET 4.7.2 on the probe Connection String: Provider=SQLOLEDB.1;Data Source=10.10.1.2;Port=5000;User ID=admin;Password=password;Initial Catalog=master
Message: Can not log in using the specified credentials!
Is the Connection String correct? May I know what value should we use for Provider?
Article Comments
Hi,
I have the same problem. I want to run query to my Sybase ASE 16 server. I tried with the SDK Driver 16, but this doesn't work, because no OLEDB Provider included. It is now deprecated from Sybase point of view. Only ADO.Net Provider directly.
So I installed the SDK 15.7 driver on my PRTG server. I could execute the query, but now, I got this strange error : XML: Structural error in xml file, 1 open items. -- JSON: The returned JSON does not match the expected structure (Invalid JSON.). (code: PE231)
Can you help me please ? Regards Philippe
Aug, 2019 - Permalink
Hello,
Would it be possible for you to run the query manually so we can see what is being sent to PRTG? We need to ensure it's in the proper format that PRTG is expecting. If you can, just post it back to this KB, and I'll take a look at it
Benjamin Day
[Paessler Support]
Aug, 2019 - Permalink
Hi,
I looked now at the result, and I think the problem comes from the 2 first line :
log4cplus:ERROR No appenders could be found for logger (com.sybase.dataaccess.oledb.<global>.DllMain).
log4cplus:ERROR Please initialize the log4cplus system properly.
?<?xml version="1.0" encoding="utf-8"?>
<prtg>
<result>
<channelid>0</channelid>
<mode>Absolute</mode>
<value>85.0085</value>
<float>1</float>
</result>
<result>
<channelid>1</channelid>
<mode>Absolute</mode>
<value>8.0008</value>
<float>1</float>
</result>
<result>
<channelid>2</channelid>
<mode>Absolute</mode>
<value>0</value>
</result>
<text />
</prtg>
Any idea where they came from ? And how I could get rid of them ? Thank you and regards Philippe RITTER
Aug, 2019 - Permalink
Hello
I found the problem. I instaleld the latest version of the driver, and it is ok. I can know run my query. I have just now to read your documentation to get the value in my sensor. Kind regards Philippe RITTER
Aug, 2019 - Permalink
Yekevca,
Which version of SyBase are you using? I've found a few links that point to using the ASE ADO.NET provider, but only if you're using Sybase Adaptive Server Enterprise.
If you let me know what kind of SyBase, I might be able to find a better fit.
Benjamin Day
Paessler Support
Mar, 2019 - Permalink