Initializing Disk Cache Error (ODBC only) - trillium_discovery - trillium_quality - 17.1

Problem

The oadm.ini is a configuration file installed with the ODBC Reporting Adapter (both 32- and 64-bit). By default, the ServiceSQLDiskCachePath=entry in oadm.ini is C:\Program Files\Trillium Software\ODBC Reporting Adapter\trillium_version\ip\cache. (If you installed the software to a different directory then the cache path will point to that directory.)

If you do not have write access to this directory, you may receive an Error initializing the disk cache message when you run a query.

Solution

Modify ServiceSQLDiskCachePath= to point to an alternative directory for which you have write access.

To modify the oadm.ini file

1. Using a text editor, open the oadm.ini file located in C:\Program Files\Trillium Software\ODBC Reporting Adapter\trillium_version\cfg.

2. Modify the ServiceSQLDiskCachePath= entry to point to an alternative location for which you have write access, for example, C:\temp\cache.

3. Save and close the file.

4. Close and reopen Excel.

5. Before you run the query again, reconfigure the data source connection.