odbcapi.h

SQLAPI C/C++ 连接Oracle 数据库！

// odbcAPI.h
//
//////////////////////////////////////////////////////////////////////

#if !defined(__ODBCAPI_H__)
#define __ODBCAPI_H__

#include "SQLAPI.h"

// API header(s)
#include <sql.h>
#include <sqlext.h>

extern long g_nODBCDLLVersionLoaded;

extern void AddODBCSupport(const SAConnection *pCon);
extern void ReleaseODBCSupport();

typedef SQLRETURN  (SQL_API *SQLAllocConnect_t)(SQLHENV EnvironmentHandle,
           SQLHDBC *ConnectionHandle);
typedef SQLRETURN  (SQL_API *SQLAllocEnv_t)(SQLHENV *EnvironmentHandle);
typedef SQLRETURN  (SQL_API *SQLAllocHandle_t)(SQLSMALLINT HandleType,
           SQLHANDLE InputHandle, SQLHANDLE *OutputHandle);
typedef SQLRETURN  (SQL_API *SQLAllocStmt_t)(SQLHDBC ConnectionHandle,
           SQLHSTMT *StatementHandle);
typedef SQLRETURN  (SQL_API *SQLBindCol_t)(
	SQLHSTMT StatementHandle, 
	SQLUSMALLINT ColumnNumber,
	SQLSMALLINT TargetType, 
	SQLPOINTER TargetValue,
	SQLLEN BufferLength, 
	SQLLEN *StrLen_or_Ind);
typedef SQLRETURN (SQL_API *SQLBindParameter_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       ipar,
    SQLSMALLINT        fParamType,
    SQLSMALLINT        fCType,
    SQLSMALLINT        fSqlType,
    SQLULEN			   cbColDef,
    SQLSMALLINT        ibScale,
    SQLPOINTER         rgbValue,
    SQLLEN		       cbValueMax,
    SQLLEN			  *pcbValue);
typedef SQLRETURN (SQL_API *SQLBrowseConnect_t)(
    SQLHDBC            hdbc,
    SQLTCHAR 		  *szConnStrIn,
    SQLSMALLINT        cbConnStrIn,
    SQLTCHAR 		  *szConnStrOut,
    SQLSMALLINT        cbConnStrOutMax,
    SQLSMALLINT       *pcbConnStrOut);
typedef SQLRETURN	(SQL_API	*SQLBulkOperations_t)(
	SQLHSTMT			StatementHandle,
	SQLSMALLINT			Operation);
typedef SQLRETURN  (SQL_API *SQLCancel_t)(SQLHSTMT StatementHandle);
typedef SQLRETURN  (SQL_API *SQLCloseCursor_t)(SQLHSTMT StatementHandle);
typedef SQLRETURN  (SQL_API *SQLColAttribute_t)(
	SQLHSTMT		StatementHandle,
    SQLUSMALLINT	ColumnNumber,
	SQLUSMALLINT	FieldIdentifier,
    SQLPOINTER		CharacterAttribute,
	SQLSMALLINT		BufferLength,
    SQLSMALLINT		*StringLength,
	SQLLEN			*NumericAttribute);
typedef SQLRETURN (SQL_API *SQLColAttributes_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       icol,
    SQLUSMALLINT       fDescType,
    SQLPOINTER         rgbDesc,
    SQLSMALLINT        cbDescMax,
    SQLSMALLINT 	  *pcbDesc,
    SQLLEN	 		  *pfDesc);
typedef SQLRETURN (SQL_API *SQLColumnPrivileges_t)(
    SQLHSTMT           hstmt,
    SQLTCHAR 		  *szCatalogName,
    SQLSMALLINT        cbCatalogName,
    SQLTCHAR 		  *szSchemaName,
    SQLSMALLINT        cbSchemaName,
    SQLTCHAR 		  *szTableName,
    SQLSMALLINT        cbTableName,
    SQLTCHAR 		  *szColumnName,
    SQLSMALLINT        cbColumnName);
typedef SQLRETURN  (SQL_API *SQLColumns_t)(SQLHSTMT StatementHandle,
           SQLTCHAR *CatalogName, SQLSMALLINT NameLength1,
           SQLTCHAR *SchemaName, SQLSMALLINT NameLength2,
           SQLTCHAR *TableName, SQLSMALLINT NameLength3,
           SQLTCHAR *ColumnName, SQLSMALLINT NameLength4);
typedef SQLRETURN  (SQL_API *SQLConnect_t)(SQLHDBC ConnectionHandle,
           SQLTCHAR *ServerName, SQLSMALLINT NameLength1,
           SQLTCHAR *UserName, SQLSMALLINT NameLength2,
           SQLTCHAR *Authentication, SQLSMALLINT NameLength3);
typedef SQLRETURN  (SQL_API *SQLCopyDesc_t)(SQLHDESC SourceDescHandle,
           SQLHDESC TargetDescHandle);
typedef SQLRETURN  (SQL_API *SQLDataSources_t)(SQLHENV EnvironmentHandle,
           SQLUSMALLINT Direction, SQLTCHAR *ServerName,
           SQLSMALLINT BufferLength1, SQLSMALLINT *NameLength1,
           SQLTCHAR *Description, SQLSMALLINT BufferLength2,
           SQLSMALLINT *NameLength2);
typedef SQLRETURN  (SQL_API *SQLDescribeCol_t)(
	SQLHSTMT		StatementHandle,
    SQLUSMALLINT	ColumnNumber,
	SQLTCHAR		*ColumnName,
	SQLSMALLINT		BufferLength,
	SQLSMALLINT		*NameLength,
	SQLSMALLINT		*DataType,
	SQLULEN			*ColumnSize,
	SQLSMALLINT		*DecimalDigits,
	SQLSMALLINT		*Nullable);
typedef SQLRETURN (SQL_API *SQLDescribeParam_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       ipar,
    SQLSMALLINT 	  *pfSqlType,
    SQLULEN		 	  *pcbParamDef,
    SQLSMALLINT 	  *pibScale,
    SQLSMALLINT 	  *pfNullable);
typedef SQLRETURN  (SQL_API *SQLDisconnect_t)(SQLHDBC ConnectionHandle);
typedef SQLRETURN (SQL_API *SQLDriverConnect_t)(
    SQLHDBC            hdbc,
    SQLHWND            hwnd,
    SQLTCHAR 		  *szConnStrIn,
    SQLSMALLINT        cbConnStrIn,
    SQLTCHAR           *szConnStrOut,
    SQLSMALLINT        cbConnStrOutMax,
    SQLSMALLINT 	  *pcbConnStrOut,
    SQLUSMALLINT       fDriverCompletion);
typedef SQLRETURN (SQL_API *SQLDrivers_t)(
    SQLHENV            henv,
    SQLUSMALLINT       fDirection,
    SQLTCHAR 		  *szDriverDesc,
    SQLSMALLINT        cbDriverDescMax,
    SQLSMALLINT 	  *pcbDriverDesc,
    SQLTCHAR 		  *szDriverAttributes,
    SQLSMALLINT        cbDrvrAttrMax,
    SQLSMALLINT 	  *pcbDrvrAttr);
typedef SQLRETURN  (SQL_API *SQLEndTran_t)(SQLSMALLINT HandleType, SQLHANDLE Handle,
           SQLSMALLINT CompletionType);
typedef SQLRETURN  (SQL_API *SQLError_t)(SQLHENV EnvironmentHandle,
           SQLHDBC ConnectionHandle, SQLHSTMT StatementHandle,
           SQLTCHAR *Sqlstate, SQLINTEGER *NativeError,
           SQLTCHAR *MessageText, SQLSMALLINT BufferLength,
           SQLSMALLINT *TextLength);
typedef SQLRETURN  (SQL_API *SQLExecDirect_t)(SQLHSTMT StatementHandle,
           SQLTCHAR *StatementText, SQLINTEGER TextLength);
typedef SQLRETURN  (SQL_API *SQLExecute_t)(SQLHSTMT StatementHandle);
typedef SQLRETURN (SQL_API *SQLExtendedFetch_t)(
    SQLHSTMT           hstmt,
    SQLUSMALLINT       fFetchType,
    SQLLEN			   irow,
    SQLULEN		 	  *pcrow,
    SQLUSMALLINT 	  *rgfRowStatus);
typedef SQLRETURN  (SQL_API *SQLFetch_t)(SQLHSTMT StatementHandle);
typedef SQLRETURN  (SQL_API *SQLFetchScroll_t)(
	SQLHSTMT		StatementHandle,
    SQLSMALLINT		FetchOrientation,
	SQLLEN			FetchOffset);
typedef SQLRETURN (SQL_API *SQLForeignKeys_t)(
    SQLHSTMT           hstmt,
    SQLTCHAR 		  *szPkCatalogName,
    SQLSMALLINT        cbPkCatalogName,
    SQLTCHAR 		  *szPkSchemaName,
    SQLSMALLINT        cbPkSchemaName,
    SQLTCHAR 		  *szPkTableName,
    SQLSMALLINT        cbPkTableName,
    SQLTCHAR 		  *szFkCatalogName,
    SQLSMALLINT        cbFkCatalogName,
    SQLTCHAR 		  *szFkSchemaName,
    SQLSMALLINT        cbFkSchemaName,
    SQLTCHAR 		  *szFkTableName,
    SQLSMALLINT        cbFkTableName);
typedef SQLRETURN  (SQL_API *SQLFreeConnect_t)(SQLHDBC ConnectionHandle);
typedef SQLRETURN  (SQL_API *SQLFreeEnv_t)(SQLHENV EnvironmentHandle);
typedef SQLRETURN  (SQL_API *SQLFreeHandle_t)(SQLSMALLINT HandleType, SQLHANDLE Handle);
typedef SQLRETURN  (SQL_API *SQLFreeStmt_t)(SQLHSTMT StatementHandle,
           SQLUSMALLINT Option);
typedef SQLRETURN  (SQL_API *SQLGetConnectAttr_t)(SQLHDBC ConnectionHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER BufferLength, SQLINTEGER *StringLength);
typedef SQLRETURN  (SQL_API *SQLGetConnectOption_t)(SQLHDBC ConnectionHandle,
           SQLUSMALLINT Option, SQLPOINTER Value);
typedef SQLRETURN  (SQL_API *SQLGetCursorName_t)(SQLHSTMT StatementHandle,
           SQLTCHAR *CursorName, SQLSMALLINT BufferLength,
           SQLSMALLINT *NameLength);
typedef SQLRETURN  (SQL_API *SQLGetData_t)(
	SQLHSTMT		StatementHandle,
    SQLUSMALLINT	ColumnNumber,
	SQLSMALLINT		TargetType,
	SQLPOINTER		TargetValue,
	SQLLEN			BufferLength,
	SQLLEN			*StrLen_or_Ind);
typedef SQLRETURN  (SQL_API *SQLGetDescField_t)(SQLHDESC DescriptorHandle,
           SQLSMALLINT RecNumber, SQLSMALLINT FieldIdentifier,
           SQLPOINTER Value, SQLINTEGER BufferLength,
           SQLINTEGER *StringLength);
typedef SQLRETURN  (SQL_API *SQLGetDescRec_t)(
	SQLHDESC		DescriptorHandle,
    SQLSMALLINT		RecNumber,
	SQLTCHAR		*Name,
	SQLSMALLINT		BufferLength,
	SQLSMALLINT		*StringLength,
	SQLSMALLINT		*Type,
	SQLSMALLINT		*SubType, 
	SQLLEN			*Length,
	SQLSMALLINT		*Precision, 
    SQLSMALLINT		*Scale,
	SQLSMALLINT		*Nullable);
typedef SQLRETURN  (SQL_API *SQLGetDiagRec_t)(
	SQLSMALLINT		HandleType,
	SQLHANDLE		Handle,
	SQLSMALLINT		RecNumber,
	SQLTCHAR		*Sqlstate,
	SQLINTEGER		*NativeError,
	SQLTCHAR		*MessageText,
    SQLSMALLINT		BufferLength,
	SQLSMALLINT		*TextLength);
typedef SQLRETURN  (SQL_API *SQLGetDiagField_t)(SQLSMALLINT HandleType, SQLHANDLE Handle,
           SQLSMALLINT RecNumber, SQLSMALLINT DiagIdentifier,
           SQLPOINTER DiagInfo, SQLSMALLINT BufferLength,
           SQLSMALLINT *StringLength);
typedef SQLRETURN  (SQL_API *SQLGetEnvAttr_t)(SQLHENV EnvironmentHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER BufferLength, SQLINTEGER *StringLength);
typedef SQLRETURN  (SQL_API *SQLGetFunctions_t)(SQLHDBC ConnectionHandle,
           SQLUSMALLINT FunctionId, SQLUSMALLINT *Supported);
typedef SQLRETURN  (SQL_API *SQLGetInfo_t)(SQLHDBC ConnectionHandle,
           SQLUSMALLINT InfoType, SQLPOINTER InfoValue,
           SQLSMALLINT BufferLength, SQLSMALLINT *StringLength);
typedef SQLRETURN  (SQL_API *SQLGetStmtAttr_t)(SQLHSTMT StatementHandle,
           SQLINTEGER Attribute, SQLPOINTER Value,
           SQLINTEGER BufferLength, SQLINTEGER *StringLength);
typedef SQLRETURN  (SQL_API *SQLGetStmtOption_t)(SQLHSTMT StatementHandle,
           SQLUSMALLINT Option, SQLPOINTER Value);
typedef SQLRETURN  (SQL_API *SQLGetTypeInfo_t)(SQLHSTMT StatementHandle,
           SQLSMALLINT DataType);
typedef SQLRETURN (SQL_API *SQLMoreResults_t)(
    SQLHSTMT           hstmt);
typedef SQLRETURN (SQL_API *SQLNativeSql_t)(
    SQLHDBC            hdbc,
    SQLTCHAR 		  *szSqlStrIn,