Oracle Connection Help

RazorSQL can connect to Oracle via either JDBC or ODBC. RazorSQL ships with the JDBC drivers necessary to connect to Oracle. Users can also connect via ODBC by setting up an ODBC data source for Oracle on their machine via the Windows data sources control panel. See below for more information on each of these connection types.

Connecting to Oracle via JDBC

Connecting to Oracle via ODBC

Connecting to Oracle via JDBC

There are two different types of JDBC connections for Oracle. These are Thin and OCI. Thin connections require no additional software to be installed other than the JDBC drivers that ship with RazorSQL. OCI drivers require the installation of the Oracle client on the machine being used to connect to Oracle. The version of the client should match up with the version of Oracle being connected to.

Connecting with the Thin Driver

To connect with the thin driver that ships with RazorSQL, you need to know the host, port, and service name or SID of the Oracle database.

Connecting with the OCI Driver

RazorSQL currently ships with the Oracle 10g drivers. If the Oracle 10g client is installed on your machine, you can use the 10g drivers to make an OCI connection. If you are connecting to a different version of Oracle, the Oracle drivers for that particular database version would need to be used in order to make an OCI connection. The only information need for an OCI connection is the name of the database to connect to.

Connecting to Oracle via ODBC

Oracle provides an ODBC driver that users can use to connect to Oracle from a Windows machine. The Oracle ODBC driver needs to be installed and an ODBC data source needs to be configured on the user's machine before connecting. ODBC drivers for Oracle can be downloaded from oracle.com.

For more information about setting up an ODBC data source, see the following link:

ODBC Setup

Manual Oracle JDBC Information

If manually configuring your connection for JDBC, see the following for JDBC driver class and JDBC URL format. Manual JDBC Information