Re: Q: Cannot connect to Informix database

In article <xldemvn5d2j.fsf@grey08.nada.kth.se>, d91-ffy@grey08.nada.kth.se (Fredrik Fyring) wrote: > Hello! > > I think I have tried all possible ways to connect to my Informix > database, > but it simply won't work. I am new to Informix and jdbc, so that might > be > the problem. > This is my server settings: > Solaris 5.5.1 > Informix 7.24 > > On my server I start the rmiserver $INFORMIXDIR/lib/java/bin/rmistart.sh > > on my client I then try: > > con = DriverManager.getConnection(url,user,passwd); > > where user,passwd is my username and password on the server machine. > To this my machine always replies: > > SQLException: XIX000:-952:User's password is not correct for the > database server. > > I have also tried to specify a password in the sysusers table, with > no more luck. Still the above mentioned error. > > Can it be any server settings? > Does anybody have any help or tips I would greatly appreciate it. > > regards > > / Fredrik Fyring > > > 952 is telling you that Unix has rejected the password as invalid, but at least you are getting to a Unix machine. Try running the Ilogin program, setting everything to what you believe is correct. If it fails then one of the settings is wrong, if it works ensure that the setnet values are the same as those you entered in ilogin. If you get as far as Ilogin working without entering values, it will use the setnet values by default, and your application is still failing then the problem is within the java. Paul Watson WF Software Ltd. Tel. (+44) 1436 674729 Fax. (+44) 1436 678693