Special Java classes that allow Java applications/applets to connect to databases
Using ODBC to Link External Databases Stored on a Database Server
Open Database Connectivity (ODBC)
API that provides a common language for application programs to access and process SQL databases independent of the particular RDBMS that is accessed
Back-end server name
User id and password
Data source name (DSN)
Windows client computer name
Client application program’s executable name
Java Database Connectivity (JDBC) is similar to ODBC, uut built specifically for Java applications
ODBC Architecture Oracle 9i Oracle ODBC driver Microsoft Access
Unix server with Oracle 9i Client with Microsoft Access ODBC
Microsoft Access Introduction – Excerpted from Wikipedia
Microsoft Access is a relational database management system from Microsoft, packaged with Microsoft Office Professional which combines the relational Microsoft Jet Database Engine with a graphical user interface .
It can use data stored in Access/Jet, SQL Server, Oracle, or any ODBC -compliant data container.
Some professional application developers use Access for rapid application development (RAD), especially for the creation of prototypes and standalone applications
Skilled software developers and data architects use it to develop powerful, complex applications.
Relatively unskilled programmers and non-programmer "power users" can use it to build simple applications without having to deal with features they don't understand.
Microsoft Access Introduction – Excerpted from Wikipedia (cont.)
Access does not scale well if data access is via a network, so applications that are used by more than a handful of people tend to rely on a Client-Server based solution such as Oracle, DB2, Microsoft SQL Server, PostgreSQL, MySQL, or MaxDB.
However, an Access "front end" (the forms, reports, queries and VB code) can be used against a host of database backends, including Access itself, SQL Server, Oracle, and any other ODBC-compliant product.