(no subject)

I am running Informix 7.20 on Windows NT 4.0. Using dbaccess to connect to the database, I can connect fine. Now, I attempt to connect via an application that I am developing and I get an error message from the database indicating that my logon was denied, my log file shows the following: @dmretcode = 53253 @dmretmsg = Logon denied. @dmengerrcode = -461 0 @dmengerrmsg = @dmengwarncode = @dmengwarnmsg = stmt = DECLARE ras1 CONNECTION FOR USER "ras" PASSWORD "dbadmin" DATABASE "ras_dev" SERVER "informix0" engine = informix IN = service GetAdminState The ras userID is the DBadmin ID for the entire database. I have no idea why I cannot logon with the above statement. What must I do. Help BadBoy

Daniel It seems to me that the number -461 is the Informix error generated by your application. Here is the error description, maybe it can help you to figure out what's going on. -461 File open error. This statement transfers a value between a file and a BYTE or TEXT column, or the statement attempts to drop a database when a required file is not available. Because the locator structure field loc_loctype was set to LOCFNAME, the database server tried to open the file using the pathname in loc_fname and the flags in loc_oflags. An operating- system error was returned. Check the accompanying ISAM error code for more information and look for operating-system messages. Typical causes include lack of disk space, file permission problems, and limits on the number of open files. Regards -- Paulo Roberto Marelli de Amorim TS&0 Consulting Brasil In article <3A783B57.E78ADA24@prolifics.com>, "Daniel S. Bravo" <dbravo@prolifics.com> wrote: > This is a multi-part message in MIME format. > --------------2FAAC5536B10501135ED9F2B > Content-Type: text/plain; charset=us-ascii > Content-Transfer-Encoding: 7bit > > I am running Informix 7.20 on Windows NT 4.0. Using dbaccess to > connect to the database, I can connect fine. Now, I attempt to connect > via an application that I am developing and I get an error message from > the database indicating that my > logon was denied, my log file shows the following: > > @dmretcode = 53253 > @dmretmsg = Logon denied. > @dmengerrcode = -461 0 > @dmengerrmsg = > @dmengwarncode = > @dmengwarnmsg = > stmt = DECLARE ras1 CONNECTION FOR USER "ras" PASSWORD > "dbadmin" DATABASE "ras_dev" > SERVER "informix0" > engine = informix > IN = service GetAdminState > > The ras userID is the DBadmin ID for the entire database. I have no > idea why I cannot logon with the above statement. > What must I do. > > Help > > BadBoy > > --------------2FAAC5536B10501135ED9F2B > Content-Type: text/x-vcard; charset=us-ascii; > name="dbravo.vcf" > Content-Transfer-Encoding: 7bit > Content-Description: Card for Daniel S. Bravo > Content-Disposition: attachment; > filename="dbravo.vcf" > > begin:vcard > n:Bravo;Daniel > tel;cell:949-283-6734 > tel;fax:949-951-8371 > tel;home:949-859-8063 > tel;work:949-951-9596 > x-mozilla-html:TRUE > url:http://www.prolifics.com > org:Prolifics;Consulting > version:2.1 > email;internet:dbravo@prolifics.com > title:Senior Consultant > adr;quoted-printable:;;15707 RockField Boulevard=0D=0ASuite #217;Irvine;CA;92618;US > note;quoted-printable:The world is immense=0D=0AAnd my time is brief=0D=0ASo my common sense=0D=0ATells me to leave=0D=0AAnd explore all things=0D=0Athat life has to give=0D=0AAnd forget inhibitions=0D=0AAnd truly LIVE!!=0D=0A > fn:Daniel S. Bravo > end:vcard > > --------------2FAAC5536B10501135ED9F2B-- > > Sent via Deja.com http://www.deja.com/

Is your application using an Informix or ODBC connection and have you checked your environment and setnet settings ?? I'd also consider upgrading ..... I had several problems with 7.2 which vanished when I went to 7.31. http://www.informix.com/evaluate/ Yours -- Earle A Long (Senior DBA) SINGLEPOINT UK LTD "Daniel S. Bravo" <dbravo@prolifics.com> wrote in message news:3A783B57.E78ADA24@prolifics.com... > I am running Informix 7.20 on Windows NT 4.0. Using dbaccess to > connect to the database, I can connect fine. Now, I attempt to connect > via an application that I am developing and I get an error message from > the database indicating that my > logon was denied, my log file shows the following: > > @dmretcode = 53253 > @dmretmsg = Logon denied. > @dmengerrcode = -461 0 > @dmengerrmsg = > @dmengwarncode = > @dmengwarnmsg = > stmt = DECLARE ras1 CONNECTION FOR USER "ras" PASSWORD > "dbadmin" DATABASE "ras_dev" > SERVER "informix0" > engine = informix > IN = service GetAdminState > > The ras userID is the DBadmin ID for the entire database. I have no > idea why I cannot logon with the above statement. > What must I do. > > Help > > BadBoy >