http://www.odbcdriver.net ODBC Driver Information Sat, 06 Jun 2009 14:07:17 +0000 http://backend.userland.com/rss092 en An application can be connected to any number of drivers and data sources. These can be a variety of drivers and data sources, the same driver and a variety of data sources, or even multiple connections to the same driver and data source. Allocating the Environment Handle The first task for any ... http://www.odbcdriver.net/connecting-to-an-odbc-data-source-of-driver/ A transaction is a unit of work that is done as a single,atomic operation; that is, the operation succeeds or fails as a whole. For example, consider transferring money from one bank account to another. This involves two steps: withdrawing the money from the first account and depositing it in ... http://www.odbcdriver.net/transactions-odbc/ Step 1: Connect to the Data Source The first step in any application is to connect to the data source. This phase, including the functions it requires, is shown in the following illustration. The first step in connecting to the data source is to load the Driver Manager and allocate the environment ... http://www.odbcdriver.net/basic-odbc-application-steps/ On computers running Microsoft® Windows NT® Server/Windows 2000 Server, Microsoft Windows NT Workstation/Windows 2000 Professional, or Microsoft Windows® 95/98, machine data source information is stored in the registry. Depending on which registry key the information is stored under, the data source is known as a user data source or a ... http://www.odbcdriver.net/odbc-data-source-example/ Data sources usually are created by the end user or a technician with a program called the ODBC Administrator. The ODBC Administrator prompts the user for the driver to use and then calls that driver. The driver displays a dialog box that requests the information it needs to connect to ... http://www.odbcdriver.net/using-odbc-data-sources/ Machine data sources are stored on the system with a user-defined name. Associated with the data source name is all of the information the Driver Manager and driver need to connect to the data source. For an Xbase data source, this might be the name of the Xbase driver, the ... http://www.odbcdriver.net/types-of-odbc-data-sources/ File Based Driver File-based drivers are used with data sources such as dBASE that do not provide a stand-alone database engine for the driver to use. These drivers access the physical data directly and must implement a database engine to process SQL statements. As a standard practice, the database engines in ... http://www.odbcdriver.net/odbc-driver-types/ 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 ... http://www.odbcdriver.net/odbc-driver-tasks/ The Driver Manager is a library that manages communication between applications and drivers. For example, on Microsoft® Windows® platforms, the Driver Manager is a dynamic-link library (DLL) that is written by Microsoft and can be redistributed by users of the redistributable MDAC 2.8 SP1 SDK. The Driver Manager exists mainly as ... http://www.odbcdriver.net/driver-manager/ An application is a program that calls the ODBC API to access data. Although many types of applications are possible, most fall into three categories, which are used as examples throughout this guide. * Generic Applications These are also referred to as shrink-wrapped applications or off-the-shelf applications. Generic applications are designed ... http://www.odbcdriver.net/odbc-applications/