Problems sometimes arise when attempting to connect to an Ingres database. This is almost always due to a misconfiguration in the user’s environment.
The following suggestions can often help detect and overcome such problems.
- Ensure you can connect to the database with the host, port, database, user name, and password using VDBA on Windows or SQL Terminal monitor.
- Ensure that the port is the two Instance Identifiers followed by the digit 7. We are connecting using the JDBC driver and the Data Access Server.
- If you try to list the tables and nothing happens, check the log file. There may have been an underlying error that didn’t generate a dialog. Usually this means a parameter does not exist or permissions are not sufficient to access the requested resource.
- If your data ends up looking garbled using a given encoding, or you get an encoding error, there might be a system and server encoding mismatch. Try using nchar/nvarchar/longnvarchar types instead.