Re: Error - 457

Prabhakar wrote: > > I have a database up and running in Informix 5 on a machine running > UnixWare. I access the DB using the "dbaccess" command from the unix > prompt which then puts me in the Informix environment with a little menu > and all. > > When I run a SQL statement on it - say "select * from table_name" it gives > me this error message: > > 457: Database server terminated unexpectedly.> > Any idea as to what this is? I can't seem to drop this table so that I > could recreate it - in case there was some problem with the data. SQL > statements work fine for other tables in the database. There is just this > one table (that incidentally has the same name as the database) that seems > to be out of sync. We also have Informix7 on that machine. Could this be > due to some version conflict? I hope your version 7.x engine is in a different directory. Try: dbaccess -V You have a problem if it says Version 7.x. :-) Otherwise, try: SELECT * FROM database_name:table_name Otherwise, you have reached a limit on the number of concurrent user sessions. Hope that helps, -- Mark. +------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | The Informix FAQ is at http://www.iiug.org | |mailto:marks@west.co.za +-----------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work, force it! | |Fax: +27 11 803 2189 |If it breaks, it needed replacing anyway!| |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+-----------------------------------------+