Crate odbc_sys 

ODBC types those representation is compatible with the ODBC C API.

This layer has not been created using automatic code generation. It is incomplete, i.e. it does not contain every symbol or constant defined in the ODBC C headers. Symbols which are deprecated since ODBC 3 have been left out intentionally. While some extra type safety has been added by grouping some of C’s #define constants into enum-types it mostly offers the same power (all) and safety guarantess(none) as the wrapped C-API. ODBC 4.0 is still under development by Microsoft, so these symbols are deactivated by default in the cargo.toml

Re-exports

pub use CDataType::ULong as Bookmark;

Structs

ConnectionAttribute

Connection attributes for SQLSetConnectAttr

Date

SQL_DATE_STRUCT

DaySecond

SQL_DAY_SECOND_STRUCT

Guid

SQLGUID

HDbc

The connection handle references storage of all information about the connection to the data source, including status, transaction state, and error information.

HDesc

HEnv

HStmt

Handle

IntervalStruct

SQL_INTERVAL_STRUCT

Lock

Lock options in crate::SQLSetPos

Nullability

Used by SQLDescribeCol.

Numeric

Equivalent of SQL_NUMERIC_STRUCT in the ODBC C API.

Operation

Operations used with crate::SQLSetPos

SqlDataType

SqlReturn

Indicates the overall success or failure of the function

Time

SQL_TIME_STRUCT

Timestamp

SQL_TIMESTAMP_STRUCT

YearMonth

SQL_YEAR_MONTH_STRUCT

Enums

AsyncConnectionBehavior

AttrConnectionPooling

Connection pool configuration

AttrCpMatch

Determines how a connection is chosen from a connection pool.

AttrOdbcVersion

ODBC verions

BulkOperation

Supported BulkOperation operations

CDataType

The C data type is specified in the SQLBindCol and SQLGetData functions with the TargetType argument and in the SQLBindParameter function with the ValueType argument.

CompletionType

Completion types for SQLEndTrans

Desc

Used in SQLColAttributeW.

DriverConnectOption

Options for SQLDriverConnect

DynamicDiagnosticIdentifier

EnvironmentAttribute

Governs behaviour of EnvironmentAttribute

FetchOrientation

Codes used for FetchOrientation in SQLFetchScroll, SQLDataSources and in SQLDrivers

FreeStmtOption

SQL Free Statement options

HandleType

Represented in C headers as SQLSMALLINT

HeaderDiagnosticIdentifier

DiagIdentifier for SQLGetDiagField

InfoType

Information requested by SQLGetInfo

Interval

ParamType

Used by SQLBindParameter.

StatementAttribute

Statement attributes are characteristics of the statement. For example, whether to use bookmarks and what kind of cursor to use with the statement’s result set are statement attributes.

Constants

C_TYPES_EXTENDED

Extended C Types range 4000 and above. Range of -100 thru 200 is reserved by Driver Manager. SQL_C_TYPES_EXTENDED.

DATA_AT_EXEC

Use this as the indicator argument to SQLBindParameter in order to indicate that the data is send at statement execution time.

IS_INTEGER

SQL_IS_INTEGER

IS_POINTER

SQL_IS_POINTER

IS_SMALLINT

SQL_IS_SMALLINT

IS_UINTEGER

SQL_IS_UINTEGER

IS_USMALLINT

SQL_IS_USMALLINT

MAX_MESSAGE_LENGTH

Maximum message length

MAX_NUMERIC_LEN

This means we use 128 bits (16 bytes) to for the numeric value. This excludes the sign, which is stored separetly.

NO_TOTAL

Indicates that the size of the value is not known. ODBC returns this value in indicator buffers for truncated values of unknown size.

NTS

NTSL

NULL_DATA

Indicates NULL values.

SQLSTATE_SIZE

SQLSTATE_SIZEW

Statics

NUM_ENVIRONMENT

Functions

SQLAllocHandle^⚠

Allocates an environment, connection, statement, or descriptor handle.

SQLBindCol^⚠

Binds application data bufferst to columns in the result set.

SQLBindParameter^⚠

Binds a buffer to a parameter marker in an SQL statement

SQLBrowseConnectW^⚠

SQLBrowseConnect supports an iterative method of discovering and enumerating the attributes and attribute values required to connect to a data source. Each call to SQLBrowseConnect returns successive levels of attributes and attribute values.

SQLBulkOperations^⚠

Performs bulk insertions and bulk bookmark operations, including update, delete, and fetch by bookmark.

SQLCancel^⚠

Cancels the processing on a statement.

SQLCancelHandle^⚠

Cancels the processing on a connection or statement.

SQLCloseCursor^⚠

Closes a cursor that has been opened on a statement and discards pending results.

SQLColAttribute^⚠

Returns descriptor information for a column in a result set. Descriptor information is returned as a character string, a descriptor-dependent value, or an integer value.

SQLColAttributeW^⚠

Returns descriptor information for a column in a result set. Descriptor information is returned as a character string, a descriptor-dependent value, or an integer value.

SQLColumnPrivilegesW^⚠

Returns a list of columns and associated privileges for the specified table. The driver returns the information as a result set on the specified StatementHandle.

SQLColumns^⚠

Returns the list of column names in specified tables. The driver returns this information as a result set on the specified StatementHandle.

SQLColumnsW^⚠

Returns the list of column names in specified tables. The driver returns this information as a result set on the specified StatementHandle.

SQLCompleteAsync^⚠

Can be used to determine when an asynchronous function is complete using either notification- or polling-based processing.

SQLConnect^⚠

SQLConnect establishes connections to a driver and a data source. The connection handle references storage of all information about the connection to the data source, including status, transaction state, and error information.

SQLConnectW^⚠

SQLConnect establishes connections to a driver and a data source. The connection handle references storage of all information about the connection to the data source, including status, transaction state, and error information.

SQLCopyDesc^⚠

Copies descriptor information from one descriptor handle to another.

SQLDataSources^⚠

Returns information about a data source. This function is implemented only by the Driver Manager.

SQLDataSourcesW^⚠

Returns information about a data source. This function is implemented only by the Driver Manager.

SQLDescribeCol^⚠

Returns the result descriptor for one column in the result set — column name, type, column size, decimal digits, and nullability.

SQLDescribeColW^⚠

Returns the result descriptor for one column in the result set — column name, type, column size, decimal digits, and nullability.

SQLDescribeParam^⚠

Returns the description of a parameter marker associated with a prepared SQL statement. This information is also available in the fields of the IPD.

SQLDisconnect^⚠

Closes the connection associated with a specific connection handle.

SQLDriverConnect^⚠

An alternative to SQLConnect. It supports data sources that require more connection information than the three arguments in SQLConnect, dialog boxes to prompt the user for all connection information, and data sources that are not defined in the system information

SQLDriverConnectW^⚠

An alternative to SQLConnect. It supports data sources that require more connection information than the three arguments in SQLConnect, dialog boxes to prompt the user for all connection information, and data sources that are not defined in the system information

SQLDrivers^⚠

Lists driver descriptions and driver attribute keywords. This function is implemented only by the Driver Manager.

SQLDriversW^⚠

Lists driver descriptions and driver attribute keywords. This function is implemented only by the Driver Manager.

SQLEndTran^⚠

Requests a commit or rollback operation for all active operations on all statements associated with a handle.

SQLExecDirect^⚠

Executes a preparable statement, using the current values of the parameter marker variables if any parameters exist in the statement. This is the fastest way to submit an SQL statement for one-time execution

SQLExecDirectW^⚠

Executes a preparable statement, using the current values of the parameter marker variables if any parameters exist in the statement. This is the fastest way to submit an SQL statement for one-time execution

SQLExecute^⚠

Executes a prepared statement, using the current values of the parameter marker variables if any paramater markers exis in the statement.

SQLFetch^⚠

SQLFetch fetches the next rowset of data from the result set and returns data for all bound columns.

SQLFetchScroll^⚠

Fetches the specified rowset of data from the result set and returns data for all bound columns. Rowsets can be specified at an absolute or relative position or by bookmark.

SQLForeignKeys^⚠

Can return:

SQLForeignKeysW^⚠

Can return:

SQLFreeHandle^⚠

Frees resources associated with a specific environment, connection, statement, or descriptor handle.

SQLFreeStmt^⚠

Stops processing associated with a specific statement, closes any open cursors associated with the statement, discards pending results, or, optionally, frees all resources associated with the statement handle.

SQLGetConnectAttr^⚠

Returns the current setting of a connection attribute.

SQLGetConnectAttrW^⚠

Returns the current setting of a connection attribute.

SQLGetCursorNameW^⚠

Returns the cursor name associated with a specified statement.

SQLGetData^⚠

SQLGetDescFieldW^⚠

Returns the current setting or value of a single field of a descriptor record.

SQLGetDescRecW^⚠

Returns the current settings or values of multiple fields of a descriptor record. The fields returned describe the name, data type, and storage of column or parameter data.

SQLGetDiagFieldW^⚠

Returns the current value of a field of a record of the diagnostic data structure (associated with a specified handle) that contains error, warning, and status information.

SQLGetDiagRec^⚠

Return the current values of multiple fields of a diagnostic record that contains eror, warning, and status information.

SQLGetDiagRecW^⚠

Return the current values of multiple fields of a diagnostic record that contains eror, warning, and status information.

SQLGetEnvAttr^⚠

Gets attributes that govern aspects of environments

SQLGetInfo^⚠

Returns general information about the driver and data source associated with a connection

SQLGetInfoW^⚠

Returns general information about the driver and data source associated with a connection

SQLGetStmtAttr^⚠

Returns the current setting of a statement attribute.

SQLGetStmtAttrW^⚠

Returns the current setting of a statement attribute.

SQLGetTypeInfo^⚠

SQLGetTypeInfo returns information about data types supported by the data source. The driver returns the information in the form of an SQL result set. The data types are intended for use in Data Definition Language (DDL) statements.

SQLMoreResults^⚠

Determines whether more results are available on a statement containing SELECT, UPDATE, INSERT, or DELETE statements and, if so, initializes processing for those results.

SQLNumParams^⚠

Returns the number of parameters in an SQL statement.

SQLNumResultCols^⚠

Returns the number of columns in a result set

SQLParamData^⚠

Used together with SQLPutData to supply parameter data at statement execution time, and with SQLGetData to retrieve streamed output parameter data.

SQLPrepare^⚠

Compiles the statement and generates an access plan.

SQLPrepareW^⚠

Compiles the statement and generates an access plan.

SQLPrimaryKeys^⚠

Create a result set which contains the column names that make up the primary key for the table.

SQLPrimaryKeysW^⚠

Create a result set which contains the column names that make up the primary key for the table.

SQLPutData^⚠

Allows an application to send data for a parameter or column to the driver at statement execution time. This function can be used to send character or binary data values in parts to a column with a character, binary, or data source-specific data type (for example, parameters of the SQL_LONGVARBINARY or SQL_LONGVARCHAR types). SQLPutData supports binding to a Unicode C data type, even if the underlying driver does not support Unicode data.

SQLRowCount^⚠

Returns the number of rows affected by an UPDATE, INSERT, or DELETE statement; an SQL_ADD, SQL_UPDATE_BY_BOOKMARK, or SQL_DELETE_BY_BOOKMARK operation in SQLBulkOperations; or an SQL_UPDATE or SQL_DELETE operation in SQLSetPos.

SQLSetConnectAttr^⚠

Sets attributes that govern aspects of connections.

SQLSetConnectAttrW^⚠

Sets attributes that govern aspects of connections.

SQLSetDescField^⚠

Sets the value of a single field of a descriptor record.

SQLSetDescFieldW^⚠

Sets the value of a single field of a descriptor record.

SQLSetEnvAttr^⚠

Sets attributes that govern aspects of environments

SQLSetPos^⚠

Sets the cursor position in a rowset and allows an application to refresh, update or delete data in the rowset.

SQLSetStmtAttr^⚠

Sets attributes related to a statement.

SQLSetStmtAttrW^⚠

Sets attributes related to a statement.

SQLTables^⚠

Returns the list of table, catalog, or schema names, and table types, stored in a specific data source. The driver returns the information as a result set

SQLTablesW^⚠

Returns the list of table, catalog, or schema names, and table types, stored in a specific data source. The driver returns the information as a result set

len_data_at_exec

Use result as the indicator argument to SQLBindParameter in order to indicate that the data is send at statement execution time. In contrast to DATA_AT_EXEC the total size is passed to the driver manager.

Type Aliases

Char

HWnd

Len

Pointer

RetCode

SChar

SetPosIRow

Row index parameter for crate::SQLSetPos

ULen

WChar

Unions

IntervalUnion

SQL_INTERVAL_UNION