ODBC Manager Constants

The following public constants are declared in the ODBC Manager:

Standard Error Codes:

Constant	Value	Meaning
#Err_NoError	0	No Error
#Err_Invalid	1	Invalid Error Code
#Err_Unknown	2	Unknown Error Code
#Err_ConnFail	3	Failed Connecting To db
#Err_ConnTimeout	4	Timed Out Waiting For db Connection
#Err_LostConn	5	Lost Connection To db
#Err_ExecTimeout	6	Obsolete, no longer used.
#Err_ExecLostConn	7	Lost The db Connection Executing Query
#Err_ODBC	8	ODBC Error Executing Query
#Err_DelNoWhere	9	DELETE Without WHERE Clause
#Err_FieldNum	10	Field Count Mismatch On Table Synch
#Err_FieldName	11	Field Name Mismatch On Table Sych
#Err_InvalidQuery	12	Invalid Query Expression
#Err_InvalidDSN	13	Invalid DSN
#Err_TransBegin	14	Error On Transaction Begin
#Err_TransEnd	15	Error On Transaction End
#Err_UserCancel	16	User Cancelled Connection
#Err_ForceDisConn	17	Error caused disconnect

Database Type Codes used in the ODBC Manager

The following numeric values are used by various functions in the library to select formatting characteristics appropriate to each database type.

Value	Meaning
0	MS SQL
1	MS Access
2	Oracle
3	MySQL
4	SyBase

Data Type Codes used in the ODBC Manager

The following numeric values are used by various functions in the library to indicate the data type of a field.

Constant	Value
#SQL_BIT	-7
#SQL_TINYINT	-6
#SQL_BIGINT	-5
#SQL_LONGVARBINARY	-4
#SQL_VARBINARY	-3
#SQL_BINARY	-2
#SQL_LONGVARCHAR	-1
#SQL_UNKNOWN_TYPE	0
#SQL_CHAR	1
#SQL_NUMERIC	2
#SQL_DECIMAL	3
#SQL_INTEGER	4
#SQL_SMALLINT	5
#SQL_FLOAT	6
#SQL_REAL	7
#SQL_DOUBLE	8
#SQL_DATE	9
#SQL_TIME	10
#SQL_TIMESTAMP	11
#SQL_VARCHAR	12