In order to configure the source connection from the interface, click Configuration and select Source Configuration.

The next screen will display parameters such as Data Source, Username, Password, Connection and Command Timeouts, and allow you to Test Connection.

Database Connection - Configure the settings needed to connect to your database

• Configuration Template - no templates are currently defined. Choose 'User Defined' to setup a connection to your database.
• Data Source - this field specifies, in loose terms, the "Database/Datasource server name" where your database system is configured to store data.
• MS SQL - this is in the form of host\sql_instance_name. Note: Only MS SQL has been tested with this custom interface.
• Database Name - the name of the database that you are connecting to.
• DBMS Type -select the appropriate type of your Hach WIMS database
• OLE DB Provider - this specifies which "database driver" the interface will use when connecting to your database and again depends on the database type:
• MS SQL - if connecting to MS SQL 2005 or later, use the native client to connect. Specify SQLNCLI as the provider. NOTE: You will need to have the Microsoft SQL Native Client installed for this to work. If connecting to MS SQL 2000, specify SQLOLEDB as the provider.
• Username - The username you want to use to connect to the database. This user should have permission to access the database and tables that contain data.
• Password - The password that will be used to connect to the database
• Connection Timeout in Seconds - how many seconds the program should wait when establishing a connection to the Hach WIMS database before aborting.
• Command Timeout in Seconds - specifies how many seconds the program should wait for a query to complete before aborting the operation.
  WARNING: Large values for these two settings can cause the program to not respond for a long period of time! Do NOT use 0 unless you know what you are doing - it will cause the program to wait indefinitely, and if your database server is down, the only way to cancel the operation is to forcefully quit the program.
• Customizations - this should be left empty unless you were told otherwise by a Hach Support Engineer or you know what you are doing.