How the iModel Connector for Smart Instrumentation Reads the Registry to find the Oracle Driver


If you run the iModel Connector for Smart Instrumentation and the installed driver field is empty, it may be due the missing registry entries. The Oracle connection in the iModel Connector for Smart Instrumentation  requires two fields to be populated:

  1. Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Oracle in OraDB19Home1

Note: The key (in red) will vary depending on the version of Oracle.

  1. Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\KEY_OraDB19Home1

Without these two registry entries the “Driver” field in the connection form will be blank (ref. Figure 1)

Figure 1 – Without Oracle Installed driver field is empty.

If you encounter this when running the connector, you can fix this by running the the Oracle 19c Database installer which will update both registry keys.

Figure 2 - The Oracle Installer Updates Both Registry Keys

 

Figure 3 - HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE Registry Key after installation

 

Figure 4 - HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI Registry Key after installation

 

Figure 5 - Driver Field is now Populated.