Hello,

I am having problems connecting via JDBC to my locally running
Informix 11.7 instance on my Mac, OS 10.6. I have this problem when
trying with a couple of a Java GUI query tools.

In /etc/services:

ol_informix117 20200/tcp
dr_informix117 21788/tcp

In sqlhosts:

demo_on onipcshm on_hostname on_servername
demo_se seipcpip se_hostname sqlexec
ol_informix117 onsoctcp localhost ol_informix117


My attempted JDBC URLs:

jdbc:informix-sqli://localhost:20200/
mydb:INFORMIXSERVER=ol_informix117
jdbc:informix-sqli://127.0.0.1:20200/
mydb:INFORMIXSERVER=ol_informix117
jdbc:informix-sqli://192.68.123.22:20200/
mydb:INFORMIXSERVER=ol_informix117

I tried different users, including the informix user and password.

The error:

com.informix.asf.IfxASFException:
Attempt to connect to database server (ol_informix117) failed.

Unfortunately the driver does not provide any additional details, such
as bad host, bad servername, bad database, bad user/password, etc.

I can connect to mydb using dbaccess just fine, including "dbaccess
mydb@ol_informix117".

When I try and telnet to localhost, port 20200, I can connect
successfully. If I send garbage the connection is aborted and there is
an message in the Informix log file. There is no message in the log
file when I fail to connect via JDBC (not sure if that is normal).

Also, there is no firewall running.

Can anyone help?

On Mar 11, 3:41*pm, Mark Jamison <maj... (AT) me (DOT) com> wrote:
Thank you for the help.

I changed sqlhosts to use 127.0.0.1, and that seemed to solve the
problem.

Thanks again!