Home : Hach WIMS Database Connection Settings
Q11976 - INFO: Hach WIMS Database Connection Settings

The database connection settings below are used in all Hach WIMS related applications that connect to the Hach WIMS central database.  This includes Hach WIMS Client, all services (i.e., Adocalc, GNR Server, Scheduler, etc.), any interface, etc. The settings and their current values can be found in each application's INI (initialization) file.  The settings are read and applied at the start of an application; therefore, if you change a setting, please be sure to restart the application or service to apply the settings.  Each setting is listed below with a description of its intended use and an example.

SETTINGS:

HACHWIMS_CONNECTION_DBTYPE
(Required)

This settings informs the application which type of database is being connected to:

  • ORACLE : HACHWIMS_CONNECTION_DBTYPE= 1
  • Microsoft SQL : HACHWIMS_CONNECTION_DBTYPE= 2

HACHWIMS_CONNECTION_PROVIDER
(Required)

This determines the OLEDB or Native Client Driver to be utilized by the application to communicate with the database:

  • ORACLE : HACHWIMS_CONNECTION_PROVIDER= OraOLEDB.Oracle
  • Microsoft SQL Server 2012, 2014, 2016, 2017 (SQL Native Client): HACHWIMS_CONNECTION_PROVIDER= SQLNCLI11
  • Microsoft SQL Server 2005, 2008 (SQL Native Client): HACHWIMS_CONNECTION_PROVIDER= SQLNCLI
  • Microsoft SQL Server 2000 (SQL OLEDB Driver): HACHWIMS_CONNECTION_PROVIDER= SQLOLEDB

HACHWIMS_CONNECTION_DATASOURCE
(Required)

This informs the application which database server or named instance is hosting the Hach WIMS Client database:

  • ORACLE : HACHWIMS_CONNECTION_DATASOURCE= localhost:1521/XE
    • Host/Server: localhost
    • TCP/IP Port: 1521
    • ORACLE 'DATABASE': XE
  • Microsoft SQL : HACHWIMS_CONNECTION_DATASOURCE = IS021\OPSSQL
    • Named Instance: OPSSQL
    • Host/Server: IS021

HACHWIMS_CONNECTION_TIMEOUT
(Optional. If not specified, value assumed to be 15)

This setting can be used to override the default database connection timeout of 15 seconds, which is how long the application will wait for a response when establishing a connection to the database. If the specific application is having trouble connecting to the database and a "time out" error is received, this setting could be increased to bypass the issue:

  • HACHWIMS_CONNECTION_TIMEOUT = 25

See 'Timeout Settings' below for more information

HACHWIMS_CONNECTION_COMMAND_TIMEOUT
(Optional. If not specified, value assumed to be 30)

This setting can be used to override the default database command timeout, which specifies how long the application will wait for a response after sending a specific command or query to the database.  If the application is getting a "command time out" error, this can help alleviate the situation:

  • HACHWIMS_CONNECTION_COMMAND_TIMEOUT = 45

See 'Timeout Settings' below for more information

HACHWIMS_CONNECTION_CUSTOMIZATIONS
(Optional)

This setting is used under certain circumstances to customize how the application connects to the database.

Timeout Settings:

The HACHWIMS_CONNECTION_TIMEOUT and HACHWIMS_CONNECTION_COMMAND_TIMEOUT settings can be set to pretty much anything you want and are measured in seconds. One important possible setting is 0 (zero). This means the application will wait indefinitely for the specified timeout condition.  This is VERY DANGEROUS and should only be used by EXPERT USERS. Also, Hach Company does not recommend using settings above 60 (1 minute) unless absolutely necessary.

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
 
Approved Comments...
No user comments available for this article.
Created on 1/29/2009 8:56 PM.
Last Modified on 11/2/2018 4:47 PM.
Last Modified by Scott Dorner.
Article has been viewed 15999 times.
Rated 6 out of 10 based on 13 votes.
Print Article
Email Article