ODBC connections
When you worked with Node.js, you learned that it was possible to connect to a database using a module called mysql
. Some applications utilize a different method of connection—known as ODBC. An ODBC connection allows a user to connect to a database through a program such as Excel, without needing to create a program to connect to the database. ODBC is the primary method of almost all application/data store connections. ODBC allows many different applications to connect to and use a data store such as MySQL databases. For this reason, you must have a good understanding of ODBC and how to use it. Some applications do not require an ODBC driver to be installed. They either install it themselves as a part of the installation or can communicate with the data store directly. Node.js does not require you to install an ODBC driver. However, Node.js still requires you to provide the connection details at some point before using the data store. With Node.js, you provide...