Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
5 replies Latest Post - ‏2009-06-01T14:31:26Z by logicatwork
SystemAdmin
SystemAdmin
1189 Posts
ACCEPTED ANSWER

Pinned topic connecting to clearquest database

‏2004-07-09T09:57:06Z |
I want to connect to a ClearQuest schema database located on some other system. What I need to do to setup the database. I tried creating a ODBC connection to that MS Access file but
clearqueatAdminSess.Logon("admin", "", "DBDSN");
does not opens the database and rather refer to the MASTR database.
I am using COM call to handle this.
Any help is appreciated.
Updated on 2009-06-01T14:31:26Z at 2009-06-01T14:31:26Z by logicatwork
  • SystemAdmin
    SystemAdmin
    1189 Posts
    ACCEPTED ANSWER

    Re:connecting to clearquest database

    ‏2004-07-09T13:49:25Z  in response to SystemAdmin
    Hi Neeraj,

    Not sure what your attempting to do, but if you want to access data in a
    ClearQuest database and have a copy of that data in ProjectConsole, you
    will need to do the following:

    1. Through ClearQuest (on the ProjectConsole server) establish a
    connection to that remote database.
    2. Use ProjectConsole's Designer to create a collection task utilizing
    this connection.
    3. Schedule the collection task to run.

    You will now have a copy of the data for specified fields in your
    ProjectConsole warehouse.

    Please refer to the ClearQuest tutorial on how to create the collection
    task.

    If this isn't what your attempting to do, please give me some further
    details.

    Cheers,

    Debra

    Debra Johnson
    Team Unifying Platform (TUP) and RU Services Specialist
    WW Technical Marketing
    Rational software
    IBM Software Group
    Boulder, CO
    Telephone: 303-558-3301
    Cell: 303-775-9168

    <neeraj@dacafe.com>
    Sent by: owner-pjc@lists.us.ibm.com
    07/09/2004 03:57 AM
    Please respond to
    pjc
    To
    pjc@lists.us.ibm.com
    cc

    Subject
    pjc connecting to clearquest database
    I want to connect to a ClearQuest schema database located on some other
    system. What I need to do to setup the database. I tried creating a ODBC
    connection to that MS Access file but
    clearqueatAdminSess.Logon("admin", "", "DBDSN");
    does not opens the database and rather refer to the MASTR database.
    I am using COM call to handle this.
    Any help is appreciated.
    <============================================================
    To unsubscribe, send email to
    majordomo@lists.us.ibm.com and put these words in the
    message body: unsubscribe pjc
    ============================================================>

    http://att1.html
    • SystemAdmin
      SystemAdmin
      1189 Posts
      ACCEPTED ANSWER

      Re: Re:connecting to clearquest database

      ‏2004-07-12T04:54:55Z  in response to SystemAdmin
      Thanks Debra for your attention. I think I need to put more information on this.
      I am trying to connect to Clear Quest using API (VB API). For connecting to ClearQuest, I am using ClearQuestAdminSession.Logon(user,pwd,db);
      Using this I can connect to the Clear Quest database and that too on the default database (when I provide empty string for db parameter). I have two ques here:
      1. How can I connect to specific database instance on my local m/c CQ server.
      2. If I want to connect to Clear Quest database on some other m/c what am I suppose to do? (is it something like creating a ODBC connection to that m/c database)?

      Thanks again
      Neeraj
      • SystemAdmin
        SystemAdmin
        1189 Posts
        ACCEPTED ANSWER

        Re:Re: Re:connecting to clearquest database

        ‏2004-07-12T06:25:34Z  in response to SystemAdmin
        Neeraj,

        These questions are better asked on the ClearQuest forum.

        ProjectConsole does not support the use of the API ...

        Cheers,

        Debra

        Debra Johnson
        Team Unifying Platform (TUP) and RU Services Specialist
        WW Technical Marketing
        Rational software
        IBM Software Group
        Boulder, CO
        Telephone: 303-558-3301
        Cell: 303-775-9168

        <neeraj@dacafe.com>
        Sent by: owner-pjc@lists.us.ibm.com
        07/11/2004 10:54 PM
        Please respond to
        pjc
        To
        pjc@lists.us.ibm.com
        cc

        Subject
        pjc Re: Re:connecting to clearquest database
        Thanks Debra for your attention. I think I need to put more information on
        this.
        I am trying to connect to Clear Quest using API (VB API). For connecting
        to ClearQuest, I am using ClearQuestAdminSession.Logon(user,pwd,db);
        Using this I can connect to the Clear Quest database and that too on the
        default database (when I provide empty string for db parameter). I have
        two ques here:
        1. How can I connect to specific database instance on my local m/c CQ
        server.
        2. If I want to connect to Clear Quest database on some other m/c what am
        I suppose to do? (is it something like creating a ODBC connection to that
        m/c database)?

        Thanks again
        Neeraj
        <============================================================
        To unsubscribe, send email to
        majordomo@lists.us.ibm.com and put these words in the
        message body: unsubscribe pjc
        ============================================================>

        http://att1.html
        • SystemAdmin
          SystemAdmin
          1189 Posts
          ACCEPTED ANSWER

          Re:Re: Re:connecting to clearquest database

          ‏2008-02-25T20:45:35Z  in response to SystemAdmin
          Hello Debra,

          I have ClearQuest and ProjectConsole installed on the same server. Except that CQ points to DB2 and ProjectConsole points to SQL Server.

          How can I "Through ClearQuest (on the ProjectConsole server) establish a connection to that remote database."?
          in order for me to see CQ data on PjC?
          Thanks
          Will
          • logicatwork
            logicatwork
            1 Post
            ACCEPTED ANSWER

            Re:Re: Re:connecting to clearquest database

            ‏2009-06-01T14:31:26Z  in response to SystemAdmin
            Kind of related question. How do i connect to multiple ClearQuest databases from ProjectConsloe? We have created seperate ClearQuest databases for each project for which i need to generate mertics from.

            Thanks
            Logic