Informix Error Messages and Error Codes From Error 1802 to 1808


Informix Error Code -1802 Connection name in use.
A connection with the same connection name has already been made. Each connection must have a unique connection name. Rename the connection, and try again.
Informix Error Code -1803 Connection does not exist.
The connection name in a SET CONNECTION or DISCONNECT statement does not refer to an established connection. Check your program to see that the connection was made and, if so, that it was not disconnected. Also, check the spelling of the connection name in the statement that is failing.

Informix Error Code -1804 Invalid database environment.
The database server cannot connect to the database environment that you specified. The server cannot locate either the database server or the database that you specified. Check the syntax of your statement. If you are specifying a database server, you must use the @ sign. You cannot use //.
Informix Error Code -1805 Invalid connection name
The connection name is invalid. It must conform to the same rules as any other identifier; that is, it can be up to 18 characters long and can contain letters, digits, and the underscore character. Also, it cannot be an ANSI reserved word. If a connection name was used with the original CONNECT TO statement, you must use the connection name in subsequent connection statements. Check that the connection name is a valid identifier and that you are using the connection name and not some other value.

Informix Error Code -1807 No connection to disconnect.
You are attempting to disconnect a connection that does not exist at this time. Check your program to see that you have not already performed a DISCONNECT statement for this connection.
Informix Error Code -1808 Reconnect to server_name server to perform the database operation.
If you connect to a database server using the CONNECT statement, you cannot implicitly reconnect to a server through one of the DATABASE statements (DATABASE, START DATABASE, and so on). You must switch to it with the SET CONNECTION statement.

Above are list of Informix Error Messages and Errors Codes or Status Codes or Exit Codes along with Error and Warning messages received while performing certain operation against Informix applications or related products.

What are Informix Error Messages?
All Informix messages returned by the Informix server are assigned an error code.

In general, each Informix error contains the following information:
• The Informix Error Code or Informix Error status
• The message text. This text is usually returned with the Error code. Some messages employ word substitution, where the word substituted represents the system-replacement of a term more specific to the occurrence.
• An explanation of how the error may have occurred.

Hope this was helpful.

SQLServerF1 Team
Information about Informix Error Codes or Status Codes or Exit Codes and Error Messages on Windows, Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *