Sams Teach Yourself SQL in 24 Hours, Second Edition

Accessing a Remote Database

Sometimes the database you are accessing is a local database, one to which you are directly connected. For the most part, you will probably access some form of a remote database. A remote database is one that is nonlocal, located on a server other than the server to which you are currently connected, meaning that you must utilize the network and some network protocol in order to interface with the database.

There are several ways to access a remote database. From a broad perspective, a remote database is accessed via the network or Internet connection using a middleware product (ODBC, a standard middleware, is discussed in the next section). Figure 23.2 shows three scenarios for accessing a remote database.

Figure ...