SQL For Dummies, 9th Edition

Chapter 17

Accessing Data with ODBC and JDBC

IN THIS CHAPTER

Finding out about ODBC

Taking a look at the parts of ODBC

Using ODBC in a client/server environment

Using ODBC on the Internet

Using ODBC on an intranet

Using JDBC

In recent years, computers have become increasingly interconnected, both within and between organizations. With this connection comes the need for sharing database information across networks. The major obstacle to the free sharing of information across networks is the incompatibility of the operating software and applications running on different machines. SQL’s creation and its ongoing evolution have been major steps toward overcoming hardware and software incompatibility.

Unfortunately, “standard” SQL is not all that standard. Even DBMS vendors who claim to comply with the international SQL standard have included proprietary extensions in their SQL implementations ...