| An API(Application Programming Interface) that ALLOWS accessing data from DIFFERENT SOURCES in a uniform manner. | It is an API for accessing DBMS (DataBase Management SYSTEM). |
| It supports both relational and non-relational databases. | It supports only relational databases. |
| It is procedural-based. | It is component-based. |
| It is easier to deploy. | It is difficult to deploy. |
| It gives a higher performance on loading and extracting the data. | It performs less compared to OLE DB on loading and extraction of data. |
| OleDbConnection = New OleDbConnection(connetionString) is used to make connection with OLE DB data source. | resource odbc_connect(string datasource , string username , string password , [int cursor_type ]) is used to make a connection to an ODBC data source. On success, this function will return a connection resource handle that is helpful in accessing the database using subsequent COMMANDS. |
