Using the interface browser for Hach WIMS Direct Server-Side Interface to Custom Q13170 StarLIMS.

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

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:  Q13170.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, the database type (1 for Oracle, 2 for MS SQL and 3 for MS Access), and Owner:

Here are some sample connection strings:

Database Type	Connection String
1. Oracle	Provider=OraOLEDB.Oracle.1;Data Source=LOCALHOST;User ID=system;Password=password;
2. MS SQL	Provider=SQLOLEDB;Data Source=LOCALHOST;initial catalog=LIMSSUPER;User Id=sa;Password=password;OLE DB Services =-2;
3. MS Access	Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\data\working.mdbUser ID=lims admin; Password=aspadmin;

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 StarLIMS interface from the dropdown menu. You are ready to view values from the StarLIMS database. Click the elipse button (three dots) on it as shown below:

When browsing for LIMS Location, Test or UD1; a screen similar to the following 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.