Re: Informix JDBC:sqli connection problem.

Sujit.Pal@bankofamerica.com wrote: > > Muchan > > For SE, you need to specify the path to the database.dbs file in your JDBC URL. > Assume your database is contained in /data/database.dbs, then your URL would > look like this. > > jdbc:informix-sqli://machine:port/ /data/database:INFORMIXSERVER=... > > Note the space between machine:port/ and the path name. I had this problem too, > till someone on this list told me about this. > > HTH > Sujit > Thanks for everyone who helped me solving the problem. With above URL, I could connect to SE server by "Direct Connection" method. ("Indirect Connection" method still fails, but I can live with one method.) and thanks Andy for the tips > catch (Exception e) > { > System.out.println(e.getErrorCode()); > System.out.println(e.getMessage()); > } it seems catch (SQLException e) { ... } works better. muchan