odbcapi.h

通用的数据库中间库

    SQLINTEGER         cbSqlStrMax,
    SQLINTEGER 		  *pcbSqlStr);
typedef SQLRETURN (SQL_API *SQLNumParams_t)(
    SQLHSTMT           hstmt,
    SQLSMALLINT 	  *pcpar);
typedef SQLRETURN  (SQL_API *SQLNumResultCols_t)(SQLHSTMT StatementHandle,
           SQLSMALLINT *ColumnCount);
typedef SQLRETURN  (SQL_API *SQLParamData_t)(SQLHSTMT StatementHandle,
           SQLPOINTER *Value);
typedef SQLRETURN (SQL_API *SQLParamOptions_t)(
    SQLHSTMT           hstmt,
    SQLUINTEGER        crow,
    SQLUINTEGER 	  *pirow);
typedef SQLRETURN  (SQL_API *SQLPrepare_t)(SQLHSTMT StatementHandle,
           SQLCHAR *StatementText, SQLINTEGER TextLength);
typedef SQLRETURN (SQL_API *SQLPrimaryKeys_t)(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName);
typedef SQLRETURN (SQL_API *SQLProcedureColumns_t)(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szProcName,
    SQLSMALLINT        cbProcName,
    SQLCHAR 		  *szColumnName,
    SQLSMALLINT        cbColumnName);
typedef SQLRETURN (SQL_API *SQLProcedures_t)(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szProcName,
    SQLSMALLINT        cbProcName);
typedef SQLRETURN  (SQL_API *SQLPutData_t)(SQLHSTMT StatementHandle,
           SQLPOINTER Data, SQLINTEGER StrLen_or_Ind);
typedef SQLRETURN  (SQL_API *SQLRowCount_t)(SQLHSTMT StatementHandle, 
	   SQLINTEGER *RowCount);
typedef SQLRETURN  (SQL_API *SQLSetConnectAttr_t)(SQLHDBC ConnectionHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER StringLength);
typedef SQLRETURN  (SQL_API *SQLSetConnectOption_t)(SQLHDBC ConnectionHandle,
           SQLUSMALLINT Option, SQLUINTEGER Value);
typedef SQLRETURN  (SQL_API *SQLSetCursorName_t)(SQLHSTMT StatementHandle,
           SQLCHAR *CursorName, SQLSMALLINT NameLength);
typedef SQLRETURN  (SQL_API *SQLSetDescField_t)(SQLHDESC DescriptorHandle,
           SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier,
           SQLPOINTER Value, SQLINTEGER BufferLength);
typedef SQLRETURN  (SQL_API *SQLSetDescRec_t)(SQLHDESC DescriptorHandle,
           SQLSMALLINT RecNumber, SQLSMALLINT Type,
           SQLSMALLINT SubType, SQLINTEGER Length,
           SQLSMALLINT Precision, SQLSMALLINT Scale,
           SQLPOINTER Data, SQLINTEGER *StringLength,
           SQLINTEGER *Indicator);
typedef SQLRETURN  (SQL_API *SQLSetEnvAttr_t)(SQLHENV EnvironmentHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER StringLength);
typedef SQLRETURN  (SQL_API *SQLSetParam_t)(SQLHSTMT StatementHandle,
           SQLUSMALLINT ParameterNumber, SQLSMALLINT ValueType,
           SQLSMALLINT ParameterType, SQLUINTEGER LengthPrecision,
           SQLSMALLINT ParameterScale, SQLPOINTER ParameterValue,
           SQLINTEGER *StrLen_or_Ind);
typedef SQLRETURN (SQL_API *SQLSetPos_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       irow,
    SQLUSMALLINT       fOption,
    SQLUSMALLINT       fLock);
typedef SQLRETURN (SQL_API *SQLSetScrollOptions_t)(    /*      Use SQLSetStmtOptions */
    SQLHSTMT           hstmt,
    SQLUSMALLINT       fConcurrency,
    SQLINTEGER         crowKeyset,
    SQLUSMALLINT       crowRowset);
typedef SQLRETURN  (SQL_API *SQLSetStmtAttr_t)(SQLHSTMT StatementHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER StringLength);
typedef SQLRETURN  (SQL_API *SQLSetStmtOption_t)(SQLHSTMT StatementHandle,
           SQLUSMALLINT Option, SQLUINTEGER Value);
typedef SQLRETURN  (SQL_API *SQLSpecialColumns_t)(SQLHSTMT StatementHandle,
           SQLUSMALLINT IdentifierType, SQLCHAR *CatalogName,
           SQLSMALLINT NameLength1, SQLCHAR *SchemaName,
           SQLSMALLINT NameLength2, SQLCHAR *TableName,
           SQLSMALLINT NameLength3, SQLUSMALLINT Scope,
           SQLUSMALLINT Nullable);
typedef SQLRETURN  (SQL_API *SQLStatistics_t)(SQLHSTMT StatementHandle,
           SQLCHAR *CatalogName, SQLSMALLINT NameLength1,
           SQLCHAR *SchemaName, SQLSMALLINT NameLength2,
           SQLCHAR *TableName, SQLSMALLINT NameLength3,
           SQLUSMALLINT Unique, SQLUSMALLINT Reserved);
typedef SQLRETURN (SQL_API *SQLTablePrivileges_t)(
    SQLHSTMT           hstmt,
    SQLCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName);
typedef SQLRETURN  (SQL_API *SQLTables_t)(SQLHSTMT StatementHandle,
           SQLCHAR *CatalogName, SQLSMALLINT NameLength1,
           SQLCHAR *SchemaName, SQLSMALLINT NameLength2,
           SQLCHAR *TableName, SQLSMALLINT NameLength3,
           SQLCHAR *TableType, SQLSMALLINT NameLength4);
typedef SQLRETURN  (SQL_API *SQLTransact_t)(SQLHENV EnvironmentHandle,
           SQLHDBC ConnectionHandle, SQLUSMALLINT CompletionType);


class SQLAPI_API odbcAPI : public saAPI
{
public:
	odbcAPI();

	SQLAllocConnect_t		SQLAllocConnect;	// 1.0
	SQLAllocEnv_t			SQLAllocEnv;		// 1.0
	SQLAllocHandle_t		SQLAllocHandle;		// 3.0
	SQLAllocStmt_t			SQLAllocStmt;		// 1.0
	SQLBindCol_t			SQLBindCol;			// 1.0
	SQLBindParameter_t		SQLBindParameter;	// 2.0
	SQLBrowseConnect_t		SQLBrowseConnect;	// 1.0
	SQLBulkOperations_t		SQLBulkOperations;	// 3.0
	SQLCancel_t				SQLCancel;			// 1.0
	SQLCloseCursor_t		SQLCloseCursor;		// 3.0
	SQLColAttribute_t		SQLColAttribute;	// 3.0
	SQLColAttributes_t		SQLColAttributes;	// 1.0
	SQLColumnPrivileges_t	SQLColumnPrivileges;// 1.0
	SQLColumns_t			SQLColumns;			// 1.0
	SQLConnect_t			SQLConnect;			// 1.0
	SQLCopyDesc_t			SQLCopyDesc;		// 3.0
	SQLDataSources_t		SQLDataSources;		// 1.0
	SQLDescribeCol_t		SQLDescribeCol;		// 1.0
	SQLDescribeParam_t		SQLDescribeParam;	// 1.0
	SQLDisconnect_t			SQLDisconnect;		// 1.0
	SQLDriverConnect_t		SQLDriverConnect;	// 1.0
	SQLDrivers_t			SQLDrivers;			// 2.0
	SQLEndTran_t			SQLEndTran;			// 3.0
	SQLError_t				SQLError;			// 1.0
	SQLExecDirect_t			SQLExecDirect;		// 1.0
	SQLExecute_t			SQLExecute;			// 1.0
	SQLExtendedFetch_t		SQLExtendedFetch;	// 1.0
	SQLFetch_t				SQLFetch;			// 1.0
	SQLFetchScroll_t		SQLFetchScroll;		// 1.0
	SQLForeignKeys_t		SQLForeignKeys;		// 1.0
	SQLFreeConnect_t		SQLFreeConnect;		// 1.0
	SQLFreeEnv_t			SQLFreeEnv;			// 1.0
	SQLFreeHandle_t			SQLFreeHandle;		// 3.0
	SQLFreeStmt_t			SQLFreeStmt;		// 1.0
	SQLGetConnectAttr_t		SQLGetConnectAttr;	// 3.0
	SQLGetConnectOption_t	SQLGetConnectOption;// 1.0
	SQLGetCursorName_t		SQLGetCursorName;	// 1.0
	SQLGetData_t			SQLGetData;			// 1.0
	SQLGetDescField_t		SQLGetDescField;	// 3.0
	SQLGetDescRec_t			SQLGetDescRec;		// 3.0
	SQLGetDiagField_t		SQLGetDiagField;	// 3.0
	SQLGetDiagRec_t			SQLGetDiagRec;		// 3.0
	SQLGetEnvAttr_t			SQLGetEnvAttr;		// 3.0
	SQLGetFunctions_t		SQLGetFunctions;	// 1.0
	SQLGetInfo_t			SQLGetInfo;			// 1.0
	SQLGetStmtAttr_t		SQLGetStmtAttr;		// 3.0
	SQLGetStmtOption_t		SQLGetStmtOption;	// 1.0
	SQLGetTypeInfo_t		SQLGetTypeInfo;		// 1.0
	SQLMoreResults_t		SQLMoreResults;		// 1.0
	SQLNativeSql_t			SQLNativeSql;		// 1.0
	SQLNumParams_t			SQLNumParams;		// 1.0
	SQLNumResultCols_t		SQLNumResultCols;	// 1.0
	SQLParamData_t			SQLParamData;		// 1.0
	SQLParamOptions_t		SQLParamOptions;	// 1.0
	SQLPrepare_t			SQLPrepare;			// 1.0
	SQLPrimaryKeys_t		SQLPrimaryKeys;		// 1.0
	SQLProcedureColumns_t	SQLProcedureColumns;// 1.0
	SQLProcedures_t			SQLProcedures;		// 1.0
	SQLPutData_t			SQLPutData;			// 1.0
	SQLRowCount_t			SQLRowCount;		// 1.0
	SQLSetConnectAttr_t		SQLSetConnectAttr;	// 3.0
	SQLSetConnectOption_t	SQLSetConnectOption;// 1.0
	SQLSetCursorName_t		SQLSetCursorName;	// 1.0
	SQLSetDescField_t		SQLSetDescField;	// 3.0
	SQLSetDescRec_t			SQLSetDescRec;		// 3.0
	SQLSetEnvAttr_t			SQLSetEnvAttr;		// 3.0
	SQLSetParam_t			SQLSetParam;		// 1.0
	SQLSetPos_t				SQLSetPos;			// 1.0
	SQLSetScrollOptions_t	SQLSetScrollOptions;// 1.0
	SQLSetStmtAttr_t		SQLSetStmtAttr;		// 3.0
	SQLSetStmtOption_t		SQLSetStmtOption;	// 1.0
	SQLSpecialColumns_t		SQLSpecialColumns;	// 1.0
	SQLStatistics_t			SQLStatistics;		// 1.0
	SQLTablePrivileges_t	SQLTablePrivileges;	// 1.0
	SQLTables_t				SQLTables;			// 1.0
	SQLTransact_t			SQLTransact;		// 1.0
};

class SQLAPI_API odbcConnectionHandles : public saConnectionHandles
{
public:
	odbcConnectionHandles();

	SQLHENV	m_hevn;
	SQLHDBC	m_hdbc;
};

class SQLAPI_API odbcCommandHandles : public saCommandHandles
{
public:
	odbcCommandHandles();

	SQLHSTMT	m_hstmt;
};

extern odbcAPI g_odbcAPI;

#endif // !defined(AFX_ODBCAPI_H__11EAA72A_EFF5_4944_8B1F_44973D30EF73__INCLUDED_)