Trouble Running Inventory Reports
Novell Cool Solutions: Tip
By David Frey
Digg 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
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:
zenworks_reports.world = (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: dfreyREMOVETHIS@genesys-computer.com after removing the words REMOVETHIS from the email address.
Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com