如题,在VC中如何实现,并且,获得ODBC数据源的函数是什么?望各位高手指点
多谢
多谢
解决方案 »
- 包含"afx.h"的问题
- DOM使用指定的Schema文件验证指定的XML为什么始终过不去呢?用XMLSpy就可以过去.急呀!!!!!!!!!!!!!!!!!!
- 高分求,如何取得另一进程中的树型控件的内容?(遍历并取出所有结点的内容)
- 《MFC深入浅出》看不懂 怎么办?
- 急!!怎么将数据库中相同名称的数据合并?
- 超级弱问题 马上结贴得分
- 开机时“嘀”的一声如何修改bios去掉
- 关于单文档中的菜单问题,高手请进!
- 对C++有深刻理解的高手请进!!!!初学者更应进,否则可以困扰你好久.....
- 怎么样使用X509的pem 格式的密钥加密字符串
- 播放*.rm格式的文件,用CRealAudio类的什么函数能使播放时不显示控制条?
- 请问如何将odbc里面各类型数据库跟connectionstring的provider关联起来?
The following table lists ODBC functions, grouped by type of task, and includes the conformance designation and a brief description of the purpose of each function. For more information about conformance designations, see “ODBC and the Standard CLI” in Chapter 1, “Introduction.” For more information about the syntax and semantics for each function, see Chapter 21, “ODBC API Reference.”An application can call the SQLGetInfo function to obtain conformance information about a driver. To obtain information about support for a specific function in a driver, an application can call SQLGetFunctions.Task Function name Conformance Purpose
Connecting to a data source SQLAllocHandle ISO 92 Obtains an environment, connection, statement, or descriptor handle.
SQLConnect ISO 92 Connects to a specific driver by data source name, user ID, and password.
SQLDriverConnect ODBC Connects to a specific driver by connection string or requests that the Driver Manager and driver display connection dialog boxes for the user.
SQLBrowseConnect ODBC Returns successive levels of connection attributes and valid attribute values. When a value has been specified for each connection attribute, connects to the data source.
Obtaining information about a driver and data source SQLDataSourcesSQLDrivers
ISO 92ODBC
Returns the list of available data sources.
Returns the list of installed drivers and their attributes.
SQLGetInfo ISO 92 Returns information about a specific driver and data source.
SQLGetFunctions ISO 92 Returns supported driver functions.
SQLGetTypeInfo ISO 92 Returns information about supported data types.
Setting and retrieving driver attributes SQLSetConnectAttr
SQLGetConnectAttr
ISO 92
ISO 92
Sets a connection attribute.
Returns the value of a connection attribute.
SQLSetEnvAttr ISO 92 Sets an environment attribute.
SQLGetEnvAttr ISO 92 Returns the value of an environment attribute.
SQLSetStmtAttr ISO 92 Sets a statement attribute.
SQLGetStmtAttr ISO 92 Returns the value of a statement attribute.
Setting and retrieving descriptor fields SQLGetDescField
SQLGetDescRec
ISO 92
ISO 92
Returns the value of a single descriptor field.
Returns the values of multiple descriptor fields.
SQLSetDescField ISO 92 Sets a single descriptor field.
SQLSetDescRec ISO 92 Sets multiple descriptor fields.
Preparing SQL requests SQLPrepare ISO 92 Prepares an SQL statement for later execution.
SQLBindParameter ODBC Assigns storage for a parameter in an SQL statement.
SQLGetCursorName ISO 92 Returns the cursor name associated with a statement handle.
SQLSetCursorName ISO 92 Specifies a cursor name.
SQLSetScrollOptions ODBC Sets options that control cursor behavior.
Submitting requests SQLExecute
SQLExecDirect
ISO 92
ISO 92
Executes a prepared statement.
Executes a statement.
SQLNativeSql ODBC Returns the text of an SQL statement as translated by the driver.
SQLDescribeParam ODBC Returns the description for a specific parameter in a statement.
SQLNumParams ISO 92 Returns the number of parameters in a statement.
SQLParamData ISO 92 Used in conjunction with SQLPutData to supply parameter data at execution time. (Useful for long data values.)
SQLPutData ISO 92 Sends part or all of a data value for a parameter. (Useful for long data values.)
Retrieving results and information about results SQLRowCountSQLNumResultCols
ISO 92ISO 92
Returns the number of rows affected by an insert, update, or delete request.
Returns the number of columns in the result set.
SQLDescribeCol ISO 92 Describes a column in the result set.
SQLColAttribute ISO 92 Describes attributes of a column in the result set.
SQLBindCol ISO 92 Assigns storage for a result column and specifies the data type.
SQLFetch ISO 92 Returns multiple result rows.
SQLFetchScroll ISO 92 Returns scrollable result rows.
SQLGetData ISO 92 Returns part or all of one column of one row of a result set (useful for long data values).
SQLSetPos ODBC Positions a cursor within a fetched block of data, and allows an application to refresh data in the rowset, or update or delete data in the result set.
SQLBulkOperations ODBC Performs bulk insertions and bulk book operations, including update, delete, and fetch by book.
SQLMoreResults ODBC Determines whether there are more result sets available and, if so, initializes processing for the next result set.
SQLGetDiagField ISO 92 Returns additional diagnostic information (a single field of the diagnostic data structure).
SQLGetDiagRec ISO 92 Returns additional diagnostic information (multiple fields of the diagnostic data structure).
Obtaining information about the data source’s system tables (catalog functions) SQLColumnPrivileges
SQLColumns
ODBC
X/Open
Returns a list of columns and associated privileges for one or more tables.
Returns the list of column names in specified tables.
SQLForeignKeys ODBC Returns a list of column names that make up foreign keys, if they exist for a specified table.
SQLPrimaryKeys ODBC Returns the list of column names that make up the primary key for a table.
SQLProcedureColumns ODBC Returns the list of input and output parameters, as well as the columns that make up the result set for the specified procedures.
SQLProcedures ODBC Returns the list of procedure names stored in a specific data source.
SQLSpecialColumns X/Open Returns information about the optimal set of columns that uniquely identifies a row in a specified table, or the columns that are automatically updated when any value in the row is updated by a transaction.
SQLStatistics ISO 92 Returns statistics about a single table and the list of indexes associated with the table.
SQLTablePrivileges ODBC Returns a list of tables and the privileges associated with each table.
SQLTables X/Open Returns the list of table names stored in a specific data source.
Terminating a statement SQLFreeStmt ISO 92 Ends statement processing, discards pending results, and, optionally, frees all resources associated with the statement handle.
SQLCloseCursor ISO 92 Closes a cursor that has been opened on a statement handle.
SQLCancel ISO 92 Cancels an SQL statement.
SQLEndTran ISO 92 Commits or rolls back a transaction.
Terminating a connection SQLDisconnect
SQLFreeHandle
ISO 92
ISO 92
Closes the connection.
Releases an environment, connection, statement, or descriptor handle.
如果配置的数据源是用户数据源, Windows系统便会修改注册表的 HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI子键;
如果配置的数据源是系统数据源, Windows系统便会修改注册表的 HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI主键在这两个键里面查找。
http://dev.csdn.net/develop/article/25/25607.shtm