A server class is assigned to each remote server. The server class specifies the access method used to interact with the server. Different types of remote servers require different access methods. The server classes provide Sybase IQ detailed server capability information. Sybase IQ adjusts its interaction with the remote server based on those capabilities.
There are currently two groups of server classes. The first is JDBC-based; the second is ODBC-based.
The JDBC-based server classes are:
asajdbc for Sybase IQ Version 12 and later, and Adaptive Server Anywhere Version 6 and later
asejdbc for Adaptive Server Enterprise and SQL Server Version 10 and later
The JDBC-based server classes are the only classes that can be used with 64-bit UNIX IQ servers.
You must create a Data Source Name (DSN) before you create an ODBC-based server class.
The ODBC-based server classes supported on all platforms:
ODBC-based server class |
Windows |
UNIX |
|---|---|---|
asaodbc for Sybase IQ Version 12 and later, and Adaptive Server Anywhere Version 5.5 and later |
Yes |
Yes |
aseodbc for Adaptive Server Enterprise and SQL Server Version 10 and later (on Windows and 32-bit Linux platforms only) |
Yes |
|
db2osbc for IBM DB2 |
Yes |
|
mssodbc for Microsoft SQL Server |
Yes |
|
oraodbc for Oracle servers (version 8.0 and later) |
Yes |
|
odbc for all other ODBC data sources |
Yes |
For a full description of remote server classes, see Chapter 17, “Server Classes for Remote Data Access.”
