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:
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.