Using the interface browser for Hach WIMS Direct Server-Side Interface to Custom TRA LabWare LIMS.

Step 1: It is important to ensure connectivity with the LabWare source database. If LabWareis on the same machine as this interface, then the browser can connect. If LabWareis on another machine, make sure it is possible to connect from the interface machine to the LabWare.  

Step 2: The browser connection must be properly configured in the Hach WIMS client:

• Select System Tables -> Entire System -> Server-Side Interface Setup.

• First, click the New Definition button to upload the definition file, the file name is:  Q12786.g2_server_lu 
• Second, add a New instance of this interface by selecting New.

To create a new entry:

1. Click New
2. Enter: the Name for Interface, Description, and select a Collector Time Zone.
   
   
   
3. Click on the Browser tab
4. Enter the Connection String, LabWare database Type, Owner, Sample ID field to use, and Test ID field to use:

Here are some sample connection strings:

Database Type	Connection String
1. Oracle	Provider=OraOLEDB.Oracle.1;Data Source=LabWare;User ID=system;Password=password;
2. MS SQL	Provider=SQLOLEDB;Data Source=LocalHost\opssql;initial catalog=LabWare;User Id=sa;Password=password;OLE DB Services =-2;
3. MS Access	Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\LabWare.mdb; User ID=admin; Password=;

While in the Hach WIMS client, click on System Setup ->Edit/View Variables and click the Interface tab.

Click on Interface To radio button and select the LabWare interface from the dropdown menu. You are ready to view values from the LabWare database. Click the elipse button (three dots) on it as shown below:

All three fields are mandatory. The CUSTOMER and SITE come from the SAMPLE table and ANALYSIS comes from the TEST table.

When browsing for the CUSTOMER, SITE, or ANALYSIS, a screen similar to this appears:

•  button will send the selected tag name back to the Hach WIMS client.
•  button will cancel selecting a tag.
•  button will allow user to find a specific tag or series of tags.
•  button will bring up help information about the interface and specifically the browser.
•  button will exit the browser without making a tag selection.
  

•  Under File we have options: OK, Cancel, Find, and Exit which work exactly the same as the shortcut buttons, explained next.
•  Under Plugin we have options: Help which displays the help for the interface, and About which shows the application information.