* Description: Knowledge of Microsoft ODBC driver
* Date: 03:37 PM EST, 06/20/2017

     |__ o. Open Database Connectivity (ODBC) is a standard application programming interface (API) for accessing database management systems (DBMS). 
     |      The designers of ODBC aimed to make it independent of database systems and operating systems. An application written using ODBC can be ported to other platforms, 
     |      both on the client and server side, with few changes to the data access code.
     |__ o. ODBC accomplishes DBMS independence by using an ODBC driver as a translation layer between the application and the DBMS. 
            The application uses ODBC functions through an ODBC driver manager with which it is linked, and the driver passes the query to the DBMS. 
            An ODBC driver can be thought of as analogous to a printer driver or other driver, providing a standard set of functions for the application to use, 
            and implementing DBMS-specific functionality.

<2> Data source:
     |__ o. Data sources are the databases or files accessed by a driver and are identified by a data source name (DSN). 
            Use the ODBC Data Source Administrator to add, configure, and delete data sources from your system. 	 

<3> ADO.NET connection string:
     |__ o. "Provider=MSDASQL;DSN=dsnName;UID=MyUserID;PWD=MyPassword;"

<4> Location of ODBC.exe:
     |__ o. C:\Windows\System32\odbcad32.exe .......... 32 bits version
     |      C:\Windows\SysWOW64\odbcad32.exe .......... 64 bits version
     |__ o. ==> Open "Control Panel"
            ==> Administrative Tool
            ==> Data Sources (ODBC) [32 bits by default]
            ==> User DSN
            ==> Add
            ==> Select driver [Oracle %CLIENT_HOME%]
            ==> Fullfile "Data Source Name/Description/TNS Service Name/User ID"
            ==> Windows ODBC only be compatiable for 32-bits Oracle client, not for 64 bits at all.

Your Comments