Specifications

20 – Using PlantScape Data in Other Applications
394 R400
Configuring the PlantScape ODBC Driver
The following procedures assume that you have already completed the
installation of the PlantScape server software as described in the Installation
Guide. Specifically, the procedures assume that:
• You have installed the PlantScape ODBC Client software on the client
computer (that is, the computer that will be used to query the PlantScape
Server database).
• You have also installed the client application (for example, Microsoft
Access) and its ODBC components, on the client computer.
The configuration procedures may vary according to the client application that
you will use to query the PlantScape server database. Application-specific help is
usually provided with the client application. In general, however, the procedures
are as follows:
1 Configure a data source on the client computer, as described in “Configuring
a Data Source” on page 394). This only needs to be done once per
computer, not every time you wish to set up a query.
2 Start up the client application and use the ODBC support provided to
connect to the PlantScape server database, as described in “Connecting to
the PlantScape Server Database” on page 396).
3 Set up a query to query the PlantScape server database.
Configuring a Data Source
To query the PlantScape server database you need a configured data source on
the client computer from which you are making the query.
Configuring a data source sets up an association between a data source name
(DSN) and an ODBC driver. Your client application will prompt you for a DSN to
connect to before sending queries to the PlantScape server database.
To configure a data source for Windows 2000:
1 Select Start
⇒
Settings
⇒
Control Panel
⇒
Administrative Tools.
2 Double-click Data Sources (ODBC). The ODBC Data Source Administrator
opens.
3 Select either the User DSN or the System DSN tab.
4 Click Add to start the Create New Data Source wizard.
5 Select PlantScape ODBC Driver from the list of installed ODBC drivers,
and click Finish to display a Setup dialog box for the selected source.
plscpcg.book Page 394 Monday, May 28, 2001 10:11 AM