Server class oraodbc

A server with server class oraodbc is Oracle version 8.0 or higher.

• Sybase certifies the use of version 8.0.03 of Oracle's ODBC driver. Configure and test your ODBC configuration using the instructions for that product.

• The following is an example of a CREATE EXISTING TABLE statement for an Oracle server named myora:

  CREATE EXISTING TABLE employees
  AT 'myora.database.owner.employees'
  

• Due to Oracle ODBC driver restrictions, you cannot issue a CREATE EXISTING TABLE for system tables. A message returns stating that the table or columns cannot be found.

Use only Sybase IQ servers running on Windows to access Oracle data. There is no 64-bit driver manager for Sybase IQ servers running on 64-bit UNIX systems.

This process tells how to create the two sets of proxy tables needed to query Oracle data in this situation.

1. Configure DirectConnect for Oracle to connect to Oracle.

2. Configure proxy tables in DirectConnect for Oracle.

3. Create a remote server in Sybase IQ using the ASEJDBC class to the server and the port number for DirectConnect for Oracle.

4. Use a CREATE EXISTING TABLE statement to create a proxy table pointing to the ASE proxy tables in DirectConnect for Oracle.

For best performance when loading large data, access the remote database with a different method from that used for queries, as follows: