SQL Error Class (12289 – 12331)
The DataFlex error system defines several classes of errors: user, system, and utility errors. The DataFlex SQL Drivers (SQL Server, DB2, and ODBC) add an error class to the DataFlex error classes and support the following errors:
| NUMBER | TEXT | DESCRIPTION |
|---|---|---|
| 12289 | General error | Database level error entry point; see the paragraph on database level errors. |
| 12290 | Can't initialize | The driver is unable to initialize. Check the database client setup. |
| 12291 | Can't de-initialize | The driver is unable to de-initialize and free up the driver environment. Check the database client setup. |
| 12292 | Bad or no primary index specified | The primary index is bad. This can be caused by several reasons. Either the index does not exist or it contains more than one segment. |
| 12293 | Login unsuccessful | Unable to login to the specified server. Either the database client is not properly set up or the user does not have sufficient privileges to login to the server. |
| 12294 | Logout unsuccessful | Unable to logout from the server. Check the database client setup. |
| 12295 | Table not in connection | An attempt is made to open a table that cannot be found on the specified server for the specified owner. |
| 12296 | Null value not allowed | An attempt has been made to put a NULL value into a column that does not allow NULL values. |
| 12297 | Segment number out of range | An attempt has been made to set or get an attribute of a non-existing index segment. |
| 12298 | Index number out of range | An attempt has been made to set or get an attribute of a non-existing index. |
| 12299 | Login attribute must be set | Structure changes have been made to the table. The Structure_End operation is missing login information for the table and is unable to save the changes. Make sure to set the DF_FILE_LOGIN attribute of the table. |
| 12300 | Physical name must be set | Trying to create a new table. The Structure_End operation is missing the physical name of the table. This is the name the table will get in the back end. Make sure to set the DF_FILE_PHYSICAL_NAME attribute. |
| 12301 | Invalid registration file | The registration file is invalid. |
| 12302 | License expired | A temporary license is expired. |
| 12303 | Deadlock or timeout | The current transaction was interrupted and rolled back because of a deadlock or timeout. For more information about handling deadlocks and/or timeouts, see Transactions. |
| 12304 | Embedded SQL error | General Embedded SQL error. |
| 12305 | Invalid SQL statement handle | A statement using the handle cannot be found for the specified connection. |
| 12306 | Invalid SQL connection handle | A connection using the handle cannot be found. |
| 12307 | Invalid SQL Driver Identifier | The driver identifier is illegal. |
| 12308 | Invalid SQL bind file | The specified bind file is not open, it is not a table connected to by the driver used for the Embedded SQL statement, or the piBindFile property has not been set. |
| 12309 | Invalid SQL column | A column with the specified number does not exist in the result set. |
| 12310 | Invalid attribute | The attribute identifier is illegal. |
| 12311 | Invalid buffer | The file passed to FetchActivatesBuffer is not open. |
| 12312 | Invalid configuration keyword | A keyword in the global configuration file is invalid. |
| 12313 | Unique index required for restructure | When restructuring an existing table, at least one unique index is required. |
| 12315 | Attempt to change a read-only field | An attempt was made to change a column for which the DF_FIELD_READ_ONLY attribute was set to RO_ERRORONCHANGE. |
| 12316 | Database property not set correctly | When using uppercase segments, the database property ARITHABORT was not set ON. (SQL Server only.) |
| 12317 | Cannot set RECNUM inactive | An attempt was made to set the RECNUM column to non-active (DF_FIELD_FETCH_STATE = FALSE) and the ReportActiveColumnErrors global attribute is set ON. |
| 12318 | Cannot change an inactive column | An attempt was made to change the value of a non-active column. |
| 12319 | The field is not active can't get value | An attempt was made to get the value of a non-active column (DF_FIELD_FETCH_STATE = FALSE) and the ReportActiveColumnErrors global attribute is set ON. |
| 12320 | Driver not properly registered | The driver is not properly registered. Run the registration program. |
| 12321 | Can't find registration file | The registration file cannot be found. Run the registration program. Registration files are: SQL Server: mssqldrv.cfg DB2: db2_drv.cfg ODBC: odbc_drv.cfg |
| 12322 | Can't read registration file | The registration file cannot be read. Run the registration program. Registration files are: SQL Server: mssqldrv.cfg DB2: db2_drv.cfg ODBC: odbc_drv.cfg |
| 12323 | Maximum number of users exceeded | The maximum number of users for the driver has been exceeded. |
| 12324 | User count file error | An error in the user count file has been detected. Run the registration program. |
| 12325 | Can't initialize user counting | An error occurred while initializing the user count system. |
| 12326 | User count file not found | The user count file was not found. Run the registration program. User count files are: SQL Server: ms.dfr DB2: db.dfr ODBC: od.dfr |
| 12327 | Can't read user count file | The user count file cannot be read. User count files are: SQL Server: ms.dfr DB2: db.dfr ODBC: od.dfr |
| 12328 | Can't decrypt user count file | The user count file cannot be decrypted. Run the registration program. User count files are: SQL Server: ms.dfr DB2: db.dfr ODBC: od.dfr |
| 12329 | Bad version of user count file | The user count file has a bad version. Run the registration program. User count files are: SQL Server: ms.dfr DB2: db.dfr ODBC: od.dfr |
| 12330 | Can't create record with recnum zero | An attempt was made to create a record with a record number that is 0 (zero) and it is not automatically filled. This is a programming error. |
| 12331 | Can't get column information | When a table is opened, the driver will get information on all the columns in the table. When getting this information fails, this error is raised. |
| 12332 | Invalid database handle | A database handle passed to identify a database when getting or setting a database level attribute is invalid. |
| 12333 | Type number out of range | An attempt was made to get a type attribute for a non-existing type. |
| 12334 | Lock error number out of range | An attempt was made to get information on an error in the deadlock/lock timeout error list that does not exist. |
| 12335 | Connection ID out of range | An attempt was made to get a DataFlex Connection ID attribute for a non-existing Connection ID. |
| 12336 | Connection ID not found | An attempt was made to find a DataFlex Connection ID by name but no Connection ID exists under that name. |
| 12337 | SQL Relation number out of range | An attempt was made to get a SQL relation attribute for a non-existing SQL relation. |
| 12338 | Not an express edition | An attempt was made to login to a non-Express Edition database server using an Express Edition Driver. |