Re: User connections, turning on logs

Klinton Lee wrote in message <7592tc$hu5$1@engnews2.Eng.Sun.COM>... >Hi All, > >Error # -1802 > - Connect type already exists. Please rename the connection. All connections >must be unique. > >Question: what causes this error? Is it possible to get this error, even though >the connection is closed? I've been told Informix is Single-Threaded. Unfortunately, >I do not know how the system is setup w/ the person who is getting this error. OK, I'm assuming NT has the same error numbers as *NIX. -1802 - Connection name in use - You are running a program that uses multiple connections to databases. (i.e. executed the statement "CONNECT TO x as 'name'") . The second time you ran the connect statement, the 'name' was the same as the first, and this is not allowed. This is because to change connections between databases, you issue the SET CONNECTION 'name' query, and change connections. It is true that Informix, although MT Safe to a certain degree, cannot have two concurrently open & active connections. > >At our site, we are getting the following errors: > >Error # -256 > ..refers to logging on the database. States that logging does not exist. >How would we turn logging on? > >On a database with logging, (we created a new database), we get the following: > On UNIX, to turn logging on (buffered) , you can use informix% ontape -s -B This requires no connections to the database, and also does a level 0 backup to TAPEDEV. Just try ontape with no args to get the other params..... HTH James