在vb中直接用odbc api访问数据库（Accessing database directly with ODBC API in VB）.docVIP

在vb中直接用odbc api访问数据库（Accessing database directly with ODBC API in VB） Accessing database directly with ODBC API in VB China Aviation Information Center Wu Bin computer worldOpen database interconnection (ODBC) has become a standard for accessing remote databases in Client/Server database application systems. As a powerful front-end development tool, Visual Basic provides developers with a variety of ways to access ODBC data sources, such as JET database engines, ODBC API functions, RDO interfaces, and so on. In comparison, programming directly using the ODBC API function is the most difficult, but access database performance is also the best. Declarative methods for ODBC API functions As with other dynamic library functions, you must declare prior to using the ODBC API function in VB Functions, constants, and data structures. The ODBC API function resides in the ODBC, running the dynamic library ODBC.DLL (16 bit) or ODBC In 32.DLL (32 bit), the dynamic library is located in the Windows subdirectory system. The usual practice is to make it separate in the VB project Use a module file, and then add the ODBC API declaration statement to it. Here is the module used in this article The content of the piece module1.bas: Declare, Function, SQLAllocEnv, Lib, odbc32.dll, phenv, As, Integer Declare, Function, SQLAllocConnect, Lib, odbc32.dll (ByVal, henv, phdbc), As, Integer Declare, Function, SQLAllocStmt, Lib, odbc32.dll (ByVal, hdbc, phstmt) AsInteger Declare Function, SQLConnect, Lib, odbc32.dll, (ByVal, hdbc, ByVal, szDSN$, ByVal, cbDSN%, ByVal, szUID$, ByVal, cbUID%, ByVal, szAuthStr$, ByVal, cbAuthStr%) As Integer Declare Function SQLColAttributesString Lib odbc32.dll Alias SQLColAttributes (ByVal hstmt, ByVal icol%, ByVal fDescType%, ByVal rgbDesc, As String, ByVal cbDescMax%, pcbDesc% pfDesc, As Integer) Declare, Function, SQLDisconnect, Lib, odbc32.dll (ByVal, hdbc), As, Integer Declare, Function, SQLExecDirect, Lib, odbc32.dll, (ByVal, hstmt, ByVal, szSql