really a just a newb question. In the case of something like an enterprise system for a company, where end-users are executing continuous reads and writes to a database, it does not appear that in most cases each workstation needs the database being used's drivers. Credentials are being passed through the software, to the databases IP and port, and I am supposing that when a new user is added to the software, it is adding them to the database and their read / write privileges are assigned at that point. The user provides their login information to the software which serves as their credentials to make read / writes to the database.
However, if I want to access the database from third-party software, Excel or what not, I then do need the drivers for the database. I guess I am not sure why this is and was wondering if someone could explain it to me.
An example, a company I used to work for used IBM DB2. We had an enterprise system around it with DB2 as the database. Using the software surrounding it, I don't recall ever needing the drivers for it. When we started writing custom reports for it in Excel, then I needed the ODBC drivers as did any other workstation that needed the Excel -> DB2 connection.