Re: (no subject)

Thank you Paul for the prompt response. I have reviewed the -461 error code and found nothing really of value in the description. I was wondering if my "declare" statement was incorrect. I believe that all users have been granted all the necessary access permissions. As a matter of fact, I believe that "all" was granted to "public". I cannot figure this thing out. I should be having problems with complex SQL queries, not a simple declare statement. Dan Paulo Amorim wrote: > 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/

"Daniel S. Bravo" wrote: > Thank you Paul for the prompt response. I have reviewed the -461 error > code and found nothing really of value in the description. I was wondering > if my "declare" statement was incorrect. I believe that all users have > been granted all the necessary access permissions. As a matter of fact, I > believe that "all" was granted to "public". I cannot figure this thing > out. I should be having problems with complex SQL queries, not a simple > declare statement. Error -461 is misleading; the finderr description does not always mention that you can get it if you have files missing under $INFORMIXDIR/msg such as itoxmsg.pam. You don't have to be messing with user-located blobs to see it. [The trouble is, someone got a file open error problem to report, looked at the messages and saw -461 File open error and didn't check to see what circumstances that number should be used in. Said someone should be shot.] Check that your INFORMIXDIR is correctly set, and that the msg file hierarchy is correct. You can particularly easily get this when using pre-7.2x code with a 7.2x server, since files moved from directly under $INFORMIXDIR/msg to $INFORMIXDIR/msg/en_us/0333 (on Unix, somewhere else under $INFORMIXDIR/msg on Win32). You might need to do some recompilation, therefore. > Paulo Amorim wrote: > > > 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: > > > > > > 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. -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"