Richard Troy wrote:
... So, the time came to do something "real" with it, which in my case starts with loading a schema. For that, I've already got a Java application that works great with Postgres, Oracle, Sybase, DB2 and Informix. Should be a snap with Ingres, I figured! (ouch!) I considered creating a vnode, but I really don't want to in the first place, and in the second place, the keyboard mapping problem won't let me run (do anything with) netutil anyway, so, I can't create a vnode even if I wanted to.
There is a workaround to use netutil and other Ingres tools in case your keyboard layout is broken: Hit ESC key, then keep SHIFT key pressed and hit O key, then P key -> cursor will jump to netutil's command prompt.
When I try to connect using my app (updated to use the Ingres version of the URL - chose NOT to put a password in the URL but rather pass it through the method that takes the username/password separately. I get the exception: DriverManager.getConnectio() exception: com.ingres.gcf.util.SqlEx: Communications error while establishing connection. I thought I'd do a port scan check but there's nothing listening on port 117 - or any other port other than ssh and Postgres. Utility ingstatus says everythng is up and running and I can get into my database with isql/ingres/sql tools. So...
If your using edbc.jar driver, check that JDBC server is turned on. For use of iijdbc.jar, turn Data Access Server on. Use cbf tool to check this.
HTH Gerhard _______________________________________________ Users mailing list Users@lists.ingres.com http://lists.ingres.com/mailman/listinfo/users