Setting Up a Working System

This topic describes the procedures you must carry out in order to set up a connection to an SQL catalog on a Reality database. It covers:

• Setting up the host to accept connections from external systems.

• Setting up an ODBC connection from a PC to a Reality data source on the host:

  • Loading the RealSQL ODBC driver on the PC.

  • Setting up the PC to recognise an SQL catalog on the Reality database.

• Setting up a JDBC connection from a client system to a Reality SQL catalog on the host, including:

  • Loading the RealSQL JDBC driver on the client system.

  • Making a JDBC connection to an SQL catalog on the Reality database.

• Troubleshooting your SQL setup.