Informix Error Messages and Error Codes From Error 11046 to 11055


Informix Error Code -11046 No data source or driver specified; dialog prohibited.
No data source or driver is specified in the connection string, and fDriverCompletion is SQL_DRIVER_NOPROMPT. Ensure that the driver keyword is in the connection string, or set the fDriverCompletion flag to SQLDriver prompt to have the driver prompt for additional connection information.
Informix Error Code -11048 Unable to load translation DLL.
The driver is unable to load the translation DLL that is specified for the data source or for the connection. Check that the name and path for the DLL are correct.

Informix Error Code -11049 Data source name too long.
The attribute value for DSN name is more than the maximum number of characters. For the accepted number of characters in the DSN name, check the INFORMIX-CLI Programmer’s Manual.
Informix Error Code -11050 Driver name too long.
The attribute value for the DRIVER keyword is more than 255 characters. Use a keyword that is less than 255 characters.
Informix Error Code -11051 DRIVER keyword syntax error.
The keyword-value pair for the DRIVER keyword contains a syntax error. Check that you entered the correct spelling and path for the driver.

Informix Error Code -11053 Base table or view already exists.
The argument szSqlStr contains a CREATE TABLE statement or a CREATE VIEW statement, and the table name or view name specified already exists. Reword the query to use a unique table name or a unique view name.
Informix Error Code -11054 Base table not found.
The argument szSqlStr contains a DROP TABLE, DROP VIEW, ALTER TABLE, CREATE VIEW, CREATE INDEX, GRANT, REVOKE, SELECT, DELETE, INSERT or UPDATE statement, but a specified table name or view name does not exist. Confirm that you are using the name of an existing table or an existing view.
Informix Error Code -11055 Index already exists.
The argument szSqlStr contains a CREATE INDEX statement, but the specified index name already exists. Reword the statement to use a unique index name.

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 *