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

It is important to ensure connectivity with the source database. 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:  Q12827.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, Table Owner, and Table for LIMS source data:

Here are some sample connection strings:

Database Type	Connection String
1. Oracle	Provider=OraOLEDB.Oracle.1;Data Source=ORA10;User ID=system;Password=password;
2. MS SQL	Provider=SQLOLEDB;Data Source=localhost;initial catalog=LIMSDATA;User Id=sa;Password=password;OLE DB Services =-2;
3. MS Access	Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\lims\working.mdb; Jet OLEDB:System Database= C:\lims\lims.mdw; User ID=; 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 interface from the dropdown menu. You are ready to view values from the LIMS database. Click the elipse button (three dots) on it as shown below:

When browsing for LIMS Location, the following screen will be shown:

When browsing for the LIMS Test, the following screen will be shown:

When browsing for LIMS UD1, the following screen will be shown:

When browsing for LIMS UD2, the following screen will be shown:

•  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.