Specifications

Configuring the PlantScape ODBC Driver
PlantScape Server and Client Configuration Guide 397
Note When querying the PlantScape database, you must connect to it as one of the
operators already configured in the PlantScape server database. The PlantScape
ODBC driver honors any area assignment restrictions that apply to that operator:
that is, operators can only see data relating to areas to which they have been
granted access.
If you are using a system DSN and want to establish a connection between the
PlantScape database and a remote SQL server you need to add an entry to the
registry.
To establish connection between the PlantScape database and a remote SQL Server:
1 Open a Command Prompt window and enter the command:
regedit
2 Go to the registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\odbc\OCBC.INI\<PlantScape
data source>
Where <PlantScape data source> is the is the data source you
configured (as described in “Configuring a Data Source” on page 394).
3 Add a new string, RemoteHost, and set the value to the name of the
computer the PlantScape Server is running on.
Setting Up Automatic Connection to the PlantScape Database
Note This section is not applicable if you are using Microsoft SQL Server 7.0.
Server Name The name of the computer on which the PlantScape Server software is
running. If you are running a redundant system, enter only the base
part of the server name. For example, if your two servers are called
hsserva and hsservb enter only hsserv as the server name. The ODBC
driver will connect automatically to the computer currently running as
primary. If you are running the query from the PlantScape Server you
can enter localhost in this field.
Redundant
Server
Check this box if you are running a system with redundant servers.
Dual LAN Check this box if you have a dual network.
In this field… Enter…
plscpcg.book Page 397 Monday, May 28, 2001 10:11 AM