Chapter 7: Connecting SQL to a Remote Database
In This Chapter
Connecting through a remote driver
Connecting through ODBC
Seeing what really happens when you make a connection
With a stand-alone desktop database system, communication is never an issue. The data-driven application you write has only one place to go for data: the database on your hard disk. Your desktop database management system (DBMS) provides the interface between your application code and the database. This simple situation, once very common, has largely been replaced by client/server database systems that reside on a local area network (LAN) or wide area network (WAN), or by Web-based systems that operate over the Internet. In these more complicated configurations, you must communicate with different database back ends in different ways.
In this chapter, I discuss client/server systems. A simple client/server system has one server machine that hosts the database. Multiple client computers are connected to the server over a LAN. Users sit at the client machines, which execute your database application program. Larger systems can have multiple servers, each holding different databases. The part of your program ...