1. Download and install Oracle OLE DB 32-bit driver from www.oracle.com 

• Sign on and navigate to the Download section. Scroll down until you see Drivers section and click on Oracle Data Access Components for Windows. We found this at:
  
  http://www.oracle.com/technetwork/developer-tools/visual-studio/downloads/index.html
  
  
• There should be a message at the top of the page like:
  
  Each 32-bit ODAC client download below supports connectivity to Oracle Database versions 9.2, 10.1, 10.2, and 11.1, and 11.2. 
  
  
  
• Find the ODAC release compatable to your version of Oracle. For example, if your Oracle version is 11.2.0.1.2, then you need ODAC 11.2 Release 2.
• Download and install the ODAC [version] with Oracle Developer Tools for Visual Studio. The important thing is that under Download includes, there is a listing for Oracle Provider for OLE DB [version]
• Once installed you can run the UDL for 32-bit using the following command, but first create the c:\test.udl file (right-click on desktop and select New > Text Document, you must see the file extension):
  
  C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl
  
  
• If you get an error on the UDL, check the file paths that the files exist and change were appropriate. Connection might be an issue; try localhost/[instance]:1521. Our instance is ORA11 so we used localhost/ora11:1521
  
  In our test, the following error appeard:
  
  
  
  
  When the Data Source was changed to localhost/ora11:1521, the connection worked as shown below. From here on out we always specified localhost/ora11:1521 when referencing the Data Source.
  
  
  
• Select save password and test connection, once you have a good connection you can look at the file using Notepad by right-clicking on the file and selecting Edit.

2. Install Hach WIMS software. Run Hach WIMS Server Setup for Oracle. Remember to always use the connection used in previous steps to connect to Oracle; in our example above we used localhost/ora11:1521. So when Server Setup asked for the instance we entered the exact same.

3. Open in Notepad: the Hach_WIMS_Client.ini file and the test.udl file.

• Make sure the Hach_WIMS_Client.ini file setting HACHWIMS_CONNECTION_PROVIDER= is the same as the test.udl file setting Provider=. In our test we had OraOLEDB.Oracle.1
• Make sure the Hach_WIMS_Client.ini file setting HACHWIMS_CONNECTION_DATASOURCE= is the same as the  test.udl file setting Data Source=. In our test we had localhost/ora11:1521