title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
---|---|---|---|---|---|---|---|---|---|---|
Driver Tasks |
Driver Tasks |
David-Engel |
davidengel |
01/19/2017 |
sql |
connectivity |
conceptual |
|
Specific tasks performed by drivers include:
-
Connecting to and disconnecting from the data source.
-
Checking for function errors not checked by the Driver Manager.
-
Initiating transactions; this is transparent to the application.
-
Submitting SQL statements to the data source for execution. The driver must modify ODBC SQL to DBMS-specific SQL; this is often limited to replacing escape clauses defined by ODBC with DBMS-specific SQL.
-
Sending data to and retrieving data from the data source, including converting data types as specified by the application.
-
Mapping DBMS-specific errors to ODBC SQLSTATEs.