Make sure that the appropriate ODBC client for Sybase, Oracle, or MS SQL is installed on the machine running ConsoleOne. The ODBC driver will be automatically configured on the machine when you invoke the Inventory report.
To install the ODBC driver for the Sybase database,
- 1. In the Novell ZENworks 6.5 Companion 2 CD, open the \database drivers directory
- 2. Follow the instructions in the ODBCreadme.txt file in the \database drivers directory. The information helps you to set up the address of the Sybase database and verify that you can make a connection
For Oracle, you must install the appropriate client for ODBC. For example, for Oracle 8i Inventory database, install the Oracle 8i client because Inventory reports are not compatible with either the older or the later version of the client.
For MS SQL, the client is available on all Microsoft Windows operating system.