ODBC-Based Server Classes

The ODBC-based server classes include:

• Defining ODBC External Servers
  The most common way of defining an ODBC-based server is to base it on an ODBC data source. To do this, you can create a data source using the ODBC Administrator.
• USING Parameter in the CREATE SERVER Statement
  You must run a separate CREATE SERVER statement for each remote database you intend to access.
• Server Class saodbc
  A server with server class saodbc is a SQL Anywhere database server. No special requirements exist for the configuration of a SQL Anywhere data source.
• Server Class ulodbc
  A server with server class ulodbc is an UltraLite database. Create an ODBC data source name defining a connection to the UltraLite database. Issue a CREATE SERVER statement for the ODBC data source name.
• Server Class adsodbc
  When you issue a CREATE TABLE statement, the database server automatically converts the data types to the corresponding Advantage Database Server data types using the following data type conversions.
• Server Class aseodbc
  A server with server class aseodbc is an Adaptive Server Enterprise (version 10 and later) database server.
• Server Class dbsodbc
  A server with server class db2odbc is IBM DB2.
• Server Class iqodbc
  A server with server class iqodbc is a SAP Sybase IQ server. No special requirements exist for the configuration of a SAP Sybase IQ data source.
• Server Class msaccessodbc
  Access databases are stored in a .mdb file. Using the ODBC manager, create an ODBC data source and map it to one of these files. A new .mdb file can be created through the ODBC manager. This database file becomes the default if you don't specify a different default when you create a table through SAP Sybase IQ.
• Server Class mssodbc
  A server with server class mssodbc is Microsoft SQL Server version 6.5, Service Pack 4.
• Server Class mysqlodbc
  When you issue a CREATE TABLE statement, the database server automatically converts the data types to the corresponding MySQL data types using the following data type conversions.
• Server Class odbc
  ODBC data sources that do not have their own server class use server class odbc. You can use any ODBC driver.
• Server Class oraodbc
  A server with server class oraodbc is Oracle version 8.0 or later.