Specifications

20 – Using PlantScape Data in Other Applications
396 R400
8 Click OK to close the ODBC Data Source Administrator dialog box.
Note • File data sources, which enable access over the network, cannot be built for
the PlantScape ODBC driver via the ODBC Administrator. If you require a
file data source:
a) Build a system data source.
b) Using any text editor, create a file containing
[ODBC]
DSN=<data source name>
Where <data source name> is the same as built in Step a above.
c) Save the file on your computer. The DSN is the name of the saved file.
• If you intend to query multiple PlantScape servers from a single client, you
need to set up a data source for each server.
Connecting to the PlantScape Server Database
Connection to the PlantScape server database via ODBC is different in each Client
application. Consult the documentation accompanying the application for details.
For a step-by-step guide for Microsoft Access see “Using PlantScape ODBC Driver
and Microsoft Access” on page 408. For information for Microsoft SQL Server 7.0
see “Using PlantScape ODBC Driver and Microsoft SQL Server” on page 413.
In general:
1 When prompted by the client application, select the data source you
configured (as described in the previous section). This displays the
Connection Details dialog box, which enables you to connect to your
PlantScape database.
2 Complete the fields as follows:
In this field… Enter…
Operator ID The user ID of an operator already configured on your PlantScape
system.
Password The corresponding password
plscpcg.book Page 396 Monday, May 28, 2001 10:11 AM