Powerbuilder Connections to Informix

Hi Informixers, I'm forwarding the following content for our applications group. The PowerBuilder usenet group has already been tried. I was asked to try the Informix forum. We appreciate any suggestions. We are using Informix 7.22 and Power Builder 5 for client/server development. We are experiencing some problems with connectivity and would like to hear from others about their solutions/work arounds. PowerSoft Technical Support told us that we should be using PBIN7050.DLL along with I-Connect v.7.20.TD1 from Informix. The above combination will allow us to connect, but with two major problems. If we tell SetNet32 (Informix's connection configuration program) to request a password at runtime (i.e. get it from the PowerBuilder login process), we get an Informix error message (-956) stating that "The desired database server does not consider the client computer or your user ID trusted. Ask the system administrator to include the client computer as a trusted host...". That will never be allowed in our environment. If we tell SetNet32 to store the user's password (encrypted in the Registry), then we can connect just fine. However, at PB application login time, the UserId / Password values provided to PowerBuilder are totally ignored and the user is allowed to connect. I can type in "X" for a UserID and "X" for a password, or anything else (as long as it has a non-zero length), and be allowed into the application. Obviously, that is not acceptable either. Do you know if others are having these same problems, or have found ways around them? We are using the PFC, if that makes a difference. We have also experimented with using ODBC, but have found problems with multiple login requirements when using multiple Connects. (My current application uses three transaction objects; one (SQLCA / n_tr) for the "home" database, one for a security system I wrote which is used in all of our applications, and another one due to the fact that we are executing Stored Procedures in a remote database). I will appreciate any help you can give. Please feel free to forward this message to anyone else you think might be able/willing to help. Thank you, John Kilgo Agency for Health Care Administration State of Florida kilgoj@fdhc.state.fl.us James May Database Administrator, Agency for Health Care Administration, Florida voice 904.922.9137 email = mayj@fdhc.state.fl.us