Novell is now a part of Micro Focus

Trouble Running Inventory Reports

Novell Cool Solutions: Tip
By David Frey

Digg This - Slashdot This

Posted: 14 Oct 2004

Also contributing: Karen Keller & Michelle Basiliere of Southwest Gas Corporation, Las Vegas


ZfD 4.0.1 IR4
ConsoleOne 1.3.6, 1.3.5
Oracle 8.1.7

When attempting to run ZENworks reports, the following error message appears: "Unable to log into the database. Ensure that the ODBC driver is installed properly."

The ZENworks inventory database is running on Oracle 8.1.7. The ODBC driver is installed correctly along with the Oracle 8.1.7 client on the PC.


A single TNSNAMES.ORA file for the enterprise is located on a shared network drive and is flagged read-only. The C1 reporting plug-in attempts to update a local copy of the file (ORACLE_HOME path) to add the zenworks_reports SID and does not "see" the shared network copy.


Manually add the ZENworks_reports SID to the TNSNAMES.ORA file: = (DESCRIPTION=ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP) 
(HOST=<x.x.x.x>)(PORT=1537))) (CONNECT_DATA=SID=<databaseSID>)))

Modify HOST=<x.x.x.x> with IP address of host
Modify SID=<databaseSID> with inv database SID

Email questions/comments to: after removing the words REMOVETHIS from the email address.

Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions.

© Copyright Micro Focus or one of its affiliates