Open Database Connectivity (ODBC) là một công nghệ để kết nối các ứng dụng cơ sở dữ liệu đã được sử dụng lâu hơn OLEDB. Không giống như OLEDB, ODBC được thiết kế để kết nối duy nhất để các nguồn RDBMS. Các trình điều khiển ODBC được bao gồm trong SNAC, tuy nhiên. | PartV Data Connectivity Open Database Connectivity ODBC is a technology for connecting applications to databases that has been in use longer than OLEDB. Unlike OLEDB ODBC is designed for connecting only to RDBMS sources. The ODBC driver is included in the SNAC however. A small set of objects is used to work with ADO. Table 32-1 lists these objects and describes how to use them. Most of these object types have a counterpart in predecessor technologies that Microsoft has introduced although the level of ADO-object functionality is much greater than that offered by previous technologies and as demonstrated next the potential usability for more recent technologies such as and XML transcends even ADO. TABLE 32-1 ADO-Object Overview Object Description Connection A connection object defines the connection with the OLEDB provider. Use this object to perform tasks such as beginning committing and rolling back transactions. There are also methods for opening or closing the connection and for executing commands. Error ADO creates an error object as part of the connection object. The error object provides additional information about errors raised by the OLEDB provider. A single error object can contain information about more than one error. Each object is associated with a specific event such as committing a transaction. Command A command object performs a task using a connection or recordset object. Even though commands can be executed as part of the connection or recordset object the command object is much more flexible and enables the definition output parameters. Parameter The parameter object defines a single parameter for a command. A parameter modifies the result of a stored procedure or query. Parameter objects can provide input output or both. Recordset The recordset object contains the result of a query and a cursor for choosing individual elements within the returned table. Record A record is a single row of data. It can stand alone or be derived from a .
