Re: Powerbuilder Connections to Informix
mayj@fdhc.state.fl.us ("May, James") wrote: >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 > Did you ever find a workaround for this --- if so, please let me know as I would like to implement it. *************************************************************** Jay Aymond United Companies Life Insurance Company Email: jay@ulife.com ***************************************************************