Specifications
20 – Using PlantScape Data in Other Applications
414 R400
To configure Microsoft SQL Server you use the DTS Wizard and includes the
following steps:
• Configuring the data source in SQL Server
• Configure the destination SQL Server database
• Selecting the tables you want to link to
• Select when data is copied
To configure Microsoft SQL Server:
1
Select Start
⇒
Programs
⇒
Microsoft SQL Server 7.0
⇒
Import and
Export Data. The DTS Wizard starts.
2
Select PlantScape Server ODBC Driver from the Source list.
3
Select the previously configured data source from the User/System DSN list.
4
Enter a PlantScape operator-based security operator ID and password. Click
Next.
5
Select Microsoft OLE DB Provider for SQL Server from the Destination list.
6
Specify the computer name on which the SQL server is running.
7
Select the SQL database name. Click Next.
8
Select Copy table(s) from the source Database. Click Next.
9
Select the PlantScape tables you want to copy. Click Next.
10
Select Run immediately to ensure PlantScape data is copied when queried.
11
Select Save to save these settings.
12
Click Finish.
plscpcg.book Page 414 Monday, May 28, 2001 10:11 AM