Hello,

i've got a mysterious problem - i'm connecting to an Informix DB via JDBC though com.informix.jdbc.IfxDriver and URL

jdbc:informix-sqli://SERVER1:4222/DBNAME:informixserver=db2_SERVER1_tcp;


Connection works perfect till now.

When executing some stupid stupid SQL Statement i also get a "Syntax Error occured" message from the DB, BUT:
when i try to execute a valid statement, i.e.
SELECT count(*) FROM SOME_VALID_TABLE

i get the following error message:

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


The problem is: i never included this db2_shm database in any of my parameter options. db2_shm is a Shared Memory Database, and could of course not be selected by native JDBC (which is TCP only).

Does anyone have an idea how these databases could be connected and why my login works until this point?

The admin told me that connecting via JDBC & ODBC works for this statement.