Archived Content: This information is no longer maintained and is provided "as is" for your convenience.
Summary
Question
Unable to connect to sybase Database usind Database query monitor
Database Sybase connection issues, driver error
Answer
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
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