Specifications

About the PlantScape ODBC Driver
PlantScape Server and Client Configuration Guide 393
About the PlantScape ODBC Driver
The PlantScape ODBC driver enables you to access PlantScape Server data (such
as history, event, access, and point data) directly from any application that
provides ODBC support; for example, Microsoft Access, Microsoft Excel, or
Crystal Reports.
The PlantScape ODBC driver has two parts: the ODBC Server and the ODBC
Client.
• The PlantScape ODBC Client handles the ODBC calls made by a client
application and passes them to the PlantScape ODBC Server.
• The ODBC Server processes the ODBC calls, queries the PlantScape Server
database and returns the information to the client application.
The PlantScape ODBC Server always runs on the PlantScape Server computer.
The PlantScape ODBC Client can run on the server or on any other computer on
the network. The following diagram shows a basic PlantScape ODBC driver
configuration.
For information about other PlantScape ODBC driver architectures refer to the
Installation Guide. For more information about ODBC, refer to the
documentation for the third-party software that you are using to query the
PlantScape database (for example, Microsoft Access).
Figure 20.1 Accessing Data via the ODBC Driver
Client
Application
Client or Server PC
Data sent
PlantScape
ODBC Client
Data requested
Data requested
Data sent
PlantScape
Database
Server PC
Data sent
Data requested
plscpcg.book Page 393 Monday, May 28, 2001 10:11 AM