Unable to connect to Sybase DB using DB query monitor

Background issue: Database Sybase connection issues, driver error

Solution Suggested:
...................................................................................................................................................................

This format in the URL fixed the issue:

jdbc:sybase:Tds:hostname:port
...................................................................................................................................................................
Additional information about Database monitor configuration for Sybase:
...................................................................................................................................................................
How to Enable SiteScope to Monitor a Sybase Database
To use JDBC drivers with your Sybase SQL server, perform the following steps:
1. Obtain the driver for the version of Sybase that you are using. For example, for version 5.X databases you need jconn2.jar. If you have Jconnect, look for a driver in the Jconnect directory.
2. Place the zip file in the \WEB-INF\lib directory. Do not extract the zip file.
3. Stop and restart the SiteScope service.
4. Add a Database Query monitor within SiteScope, and configure the following settings in the Monitor Settings panel:
• Database connection URL. Use the syntax of: jdbc:sybase:Tds:hostname:port
• For example to connect to SQL server named bsu listening on port 2408, you would enter:
jdbc:sybase:Tds:bsu:2408
• You can specify a database by using the syntax:
• jdbc:sybase:Tds:hostname:port#/database
For example to connect to SQL server named bsu listening on port 2408 and to the database of quincy, you would enter:
jdbc:sybase:Tds:bsu:2408/quincy
• Database driver. Enter com.sybase.jdbc.SybDriver (for Sybase version 4.x) or com.sybase.jdbc2.jdbc.SybDriver (for Sybase version 5.x).
• Enter the Database user name and Database password.
• Enter a query string for a database instance and table in the Sybase database you want to monitor.
• For example, Sp_help should work and return something similar to:
good, 0.06 sec, 27 rows, KIRK1, dbo, user table
Alternately, the query string select * from spt_ijdbc_mda should return something similar to:
Monitor: good, 0.06 sec, 175 rows, CLASSFORNAME, 1, create table #tmp_class_for_name (xtbinaryoffrow image null), sp_ijdbc_class_for_name(?), select * from #tmp_class_for_name, 1, 7, 12000, -1