I am trying to connect to an Informix database. In the Windows ODBC setup, I have the Informix ODBC driver, and ‘Test Connection’ works okay. The error I get with FPMI is:
FAIL (next test in 8 seconds)
Message: (show details)
[Informix][Informix ODBC Driver][Informix]Incorrect password or user SYSTEM is not known on the database server.
The IT dept. has this connection setup for me. There is no username/password in the ODBC setup in Windows. I think there is some hostname-based authentication going on… It seems that FPMI forces the username/password fields, and when I leave them blank, it uses ‘SYSTEM’. The field ‘Extra Connection Properties’ in FPMI has this note:
NOTE - The user and password properties will be passed explicitly, so they do not need to be included here.
I am wondering if it would work if FPMI didn’t include the uname/passwd in it’s connection settings. Has anyone run into this before?
I have also tried using the Informix JDBC driver, to no avail. Here’s the message:
[i]FAIL (next test in 6 seconds)
Message: (show details)
Incorrect password or user com.informix.asf.IfxASFRemoteException: is not known on the database server.[/i]
That is with the username blank. If I try it with a username, it says no system permission.
Any thoughts?
Thanks,
Matt