Sybase JDBC

Sybase

Connecting to Sybase databases

Omniscope comes with embedded jTDS driver which supprts connectivity to Sybase connectivity.

You do not have to install any drivers for connecting to Sybase.

Column-oriented Sybase databases may not be supported by jTDS driver. In this case you may need to use JDBC (Advanced) option.

Please read SybaseIQ section below for more information.

Sybase IQ

If you can not connect to Sybase database using the embedded jTDS driver.

We have verified that the following configuration works in Omniscope:

Sybase IQ 15.2 with jConnect 6
Installed locally on Windows 7 x64 with the sample database "iqdemo"
Connecting using Omniscope 2.6 b580

The Omniscope 2.6 database configuration required was:

Select database: JDBC (Advanced)
Driver jar path: C:\Sybase\jConnect-6_0\classes\jconn3.jar
Driver class: com.sybase.jdbc3.jdbc.SybDriver
JDBC URL: jdbc:sybase:Tds:localhost:2638?ServiceName=iqdemo
Username: dba
Password: sql

Note there is a bug in the Sybase JDBC driver "jConnect" which prevents Omniscope from providing a list of tables to choose. Instead you must choose "Custom SQL" and enter "SELECT * FROM Contacts" (for example).

This is likely to be a networking issue, most likely to do with proxy settings. Please refer to our Knowledge Base page on this, in particular "Diagnosing proxy settings issues":

http://www.visokio.com/kb/proxysettings

Also try installing Omniscope on the database server directly, if possible, to rule out networking issues and to ensure you have the correct database connection settings.