To return expected results, you can:

  • Reduce the number of search terms. Each term you use focuses the search further.
  • Check your spelling. A single misspelled or incorrectly typed term can change your result.
  • Try substituting synonyms for your original terms. For example, instead of searching for "java classes", try "java training"
  • Did you search for an IBM acquired or sold product ? If so, follow the appropriate link below to find the content you need.
  • Cause

    While attempting to access or upgrade a user database, you might encounter an error such as:
    SQLDriverConnect: RETCODE=-1, State=37000, Native
    Error=4060 [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open
    database required.

    Your database is in an inconsistent state

    Resolving The Problem

    These errors can occur if the SQL Server database is set to "Single User" or if Server Roles have been set. To resolve these errors:

  • If "Single User" access is set for the database, set it back to DBOwner .
  • Open the SQL server login properties for the login user. Select Server Roles and verify that all Server roles are not selected.
  • Note: If this error occurred during a database upgrade, and the upgrade failed, you will have to unlock your user database. See technote 1133810 for details on "How to unlock a ClearQuest database that has been locked". [{"Product":{"code":"SSSH5A","label":"Rational ClearQuest"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Database Configuration\/Connectivity - SQL Server","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.00;2002.05.20;2003.06.00;2003.06.12;2003.06.13;2003.06.14;2003.06.15;2003.06.16;7.0;7.0.0.1;7.0.1;7.0.0.2","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]