Ingres Connection Help

The preferred way for connecting to Ingres with RazorSQL is via JDBC. It is also possible to connect to Ingres via ODBC with RazorSQL. See below for more information on each of these connection types.

Connecting to Ingres via JDBC

RazorSQL does not ship with the Ingres JDBC drivers. To get connected to Ingres, the JDBC drivers must first be obtained. The JDBC driver is included with the Ingres installation under the lib directory. The name of the JDBC driver file is iijdbc.jar

If you do not have an Ingres installation, the JDBC driver can be obtained from the Ingres community. Registration is required for download. For more information, click the following link:

Once the JDBC driver is obtained, users can connect to Ingres by launching the connection wizard and selecting Ingres as the database type and JDBC (Ingres Driver) as the connection type. Click the browse button to the location of the iijdbc.jar file and enter any login information and the host or ip address of the server, the port the server is listening on, and the database name.

Manual Ingres JDBC Information

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

Connecting to Ingres via ODBC

To get connected with ODBC, the Ingres ODBC driver must be installed on your machine, and an ODBC datasource for Ingres must be configured on the user's machine prior to connecting. For more information on setting up ODBC datasources, see the following:

ODBC Setup

Once the ODBC driver is installed and an ODBC datasource is configured, open the connection wizard, select Ingres as the database type, ODBC as the connection type, and select the name of the ODBC datasource you configured to make an ODBC connection to Ingres.