Connecting to Sysbase ASE DB

Hi. I'm trying to connect in my PRTG server to monitoring ASE Database but, I'm not finding a default connection to this database on creation of the Sensor like "Oracle SQL v2" and etc. Is there a way to do it? If don't, any prediction?

ase prtg sysbase

Created on Aug 30, 2016 3:22:58 PM by Rodrigofl (0) ●1

Best Answer

Accepted Answer

Votes:

0

Your Vote:

It looks as if a semi-colon after the provider is missing in the connection string:

Provider=ASEOLEDB; Data Source=<IP>\ECD;Port=4901;Catalog=saptools;User id=sapsa;Password=<PASS>;EncryptPassword=1;

Created on Sep 1, 2016 12:38:03 PM by Torsten Lindner [Paessler Support]

3 Replies

Votes:

0

Your Vote:

Hello,

Thank you very much for your KB-Post. I'm very much afraid there is no native ASE DB Sensor, nor are there plans for it. You can try to monitor your DB though using the generic ADO SQL Sensor, once you've created an according connection between DB & PRTG Host.

best regards.

Created on Aug 31, 2016 11:26:53 AM by Torsten Lindner [Paessler Support]

Votes:

0

Your Vote:

Hi, thank you for your reply.

I did try with ADO SQL Sensor, but I'm getting error "Can not log in using the specified credentials!". I'm sure that my Windows and Database credentials are correct.

My string connection is (according to this site "http://www.connectionstrings.com/sybase-adaptive/"):

Provider=ASEOLEDB Data Source=<IP>\ECD;Port=4901;Catalog=saptools;User id=sapsa;Password=<PASS>;EncryptPassword=1;

Do you have some example of it? Or any suggestion?

Created on Aug 31, 2016 12:29:57 PM by Rodrigofl (0) ●1

Accepted Answer

Votes:

0

Your Vote:

It looks as if a semi-colon after the provider is missing in the connection string:

Provider=ASEOLEDB; Data Source=<IP>\ECD;Port=4901;Catalog=saptools;User id=sapsa;Password=<PASS>;EncryptPassword=1;

Created on Sep 1, 2016 12:38:03 PM by Torsten Lindner [Paessler Support]