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. Oh... :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. Strange... :-) :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. He... :-) :Do you know if others are having these same problems, Yes. : or have found ways :around them? No, I don't know. : 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). Have you tried the OpenLink server based ODBC driver. This should be capable of doing what you want. :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. May be you could talk to Informix and tell them about this. Please ask for the manager of the support department you use, not the first one you get to unless that person realy understands the issues. This is an area where Informix realy need to pull themselves together. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org