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. The 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 thedriverenvironment. Check the database client setup.

12192

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 setup 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 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 an 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<serial number>.dfr

DB2: db<serial number>.dfr

ODBC: od<serial number>.dfr

12327

Can't read user count file

The user count file cannot be read. User count files are:

SQL Server: ms<serial number>.dfr

DB2: db<serial number>.dfr

ODBC: od<serial number>.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<serial number>.dfr

DB2: db<serial number>.dfr

ODBC: od<serial number>.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<serial number>.dfr

DB2: db<serial number>.dfr

ODBC: od<serial number>.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.