DX Operational Intelligence

Tech Tip: Capacity Manager error Unknown Error connecting to Data Manager

  • 1.  Tech Tip: Capacity Manager error Unknown Error connecting to Data Manager

    Posted 09-23-2015 04:40 PM


    Problem:

    While trying to set up ODBC connection to DM from Capacity Manager 5.2, get error:

    Error Connecting to Data Manager
    Unknown Error connecting to Data Manager

    CapManODBC_error.jpg

     

    In ODBC Manager, while selecting an Oracle ODBC driver, we see that the Version and Company columns show "Not Marked".  There may be a problem with the Oracle odbc driver you are using if it displays "Not Marked".  This normally would present a version.  If during the set up of the New Data Source in ODBC Manager, you see an error 126 or 193 error code, this can indicate that the driver did not properly register during install.

     

    Solution:

    If there is another Oracle ODBC driver in the list, try using that one.  Capacity Manager uses the 64 bit Oracle ODBC driver and it may need to be installed or in case of error, reinstalled.  The Capacity Manager installer will install the Oracle Database instant client if another client is not present.

    Also, if needed you can get the Oracle ODBC driver from the below location.

    Instant Client Downloads for Microsoft Windows (x64)
    http://www.oracle.com/technetwork/topics/winx64soft-089540.html