Informix SE - JDBC problem

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C04AB7.93A1E94A Content-Type: text/plain; charset="iso-8859-1" I have JDBC for informix SE installed on HPUX 10.20. When i use the JDBC to connect to a database, the only user i am able to connect to a database with is a super user (root) - permissions right? i can't find where.... - the c-isam files are read/write world - in the DB engine i can connect to DBserver/database specifically as user/password over the sesoctcp service (from dbaccess). - java is able to read and write files using normal file permission. If i use a connect string with username and password, then the JDBC fails to connect to the database, even if the username and password in the connect string is the same as that of the superuser running the JDBC app from command line. But if i run the same program with no username/password, i can get a connection (but only as a superuser). Versions: Java jdk1.1.8 JDBC 1.40 Informix SE 7.24.UC1 sqlexed is running as sesoctcp does anyone have any information that might help? NOTICE: CONFIDENTIAL COMMUNICATION This e-mail message and any accompanying files may contain information that is confidential and subject to privilege. If you are not the intended recipient, and have received the e-mail in error, you are notified that any use, dissemination, distribution, forwarding, printing or copying of the message and any attached files is strictly prohibited. If you have received this e-mail message in error please immediately advise the sender by return e-mail, or telephone, listed below. You must destroy the original transmission and its contents. Any views expressed within this communication are those of the individual sender, except where the sender specifically states them to be the views of Ramsay Health Care. This communication should not be copied or disseminated without permission. ------------------------------------------------------------------------ "Greenslopes Private Hospital" a member of Ramsay Health Care Telephone: 61 7 3394 7111 Facsimile: 61 7 3394 7322 ------_=_NextPart_001_01C04AB7.93A1E94A Content-Type: text/html; charset="iso-8859-1" <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <META content="MSHTML 5.00.3103.1000" name=GENERATOR></HEAD> <BODY> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>I have JDBC for informix SE installed on HPUX 10.20.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>When i use the JDBC to connect to a database,&nbsp;the only user i am able to connect to a database with is a super user (root) - permissions right? i can't find where....</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>- the c-isam files are read/write world</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>- in the DB engine i can connect to DBserver/database specifically as user/password over the sesoctcp service (from dbaccess).</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>- java is able to read and write files using normal file permission.</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>If i use a connect string with username and password, then the JDBC fails to connect to the database, even if the username and password in the connect string is the same as that of the superuser running the JDBC app&nbsp;from command line.&nbsp; But if&nbsp;i run the same program with no username/password, i can get a connection (but only as a superuser).</SPAN></FONT></DIV> <DIV>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>Versions:</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>Java jdk1.1.8</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>JDBC 1.40</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>Informix SE 7.24.UC1</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>sqlexed is running as sesoctcp</SPAN></FONT></DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000></SPAN></FONT>&nbsp;</DIV> <DIV><FONT face=Arial size=2><SPAN class=234550700-10112000>does anyone have any information that might help?</SPAN></FONT></DIV><CODE><FONT SIZE=3><BR> <BR> NOTICE: CONFIDENTIAL COMMUNICATION<BR> This e-mail message and any accompanying files may contain<BR> information that is confidential and subject to privilege. If you<BR> are not the intended recipient, and have received the e-mail<BR> in error, you are notified that any use, dissemination,<BR> distribution, forwarding, printing or copying of the message <BR> and any attached files is strictly prohibited. If you have<BR> received this e-mail message in error please immediately <BR> advise the sender by return e-mail, or telephone, listed below.<BR> You must destroy the original transmission and its contents. <BR> Any views expressed within this communication are those of<BR> the individual sender, except where the sender specifically<BR> states them to be the views of Ramsay Health Care. <BR> This communication should not be copied or disseminated <BR> without permission.<BR> ------------------------------------------------------------------------<BR> </FONT></CODE><CODE><FONT SIZE=3><BR> <BR> "Greenslopes Private Hospital" a member of Ramsay Health Care <BR> Telephone: 61 7 3394 7111<BR> Facsimile: 61 7 3394 7322<BR> </FONT></CODE></BODY></HTML> ------_=_NextPart_001_01C04AB7.93A1E94A--