Topic
6 replies Latest Post - ‏2013-03-17T12:23:21Z by rajendrak
stoned99
stoned99
44 Posts
ACCEPTED ANSWER

Pinned topic Visual Studio Add-In stopped working with licensing problem

‏2013-03-11T21:33:10Z |
I've been successfully using DS 3.2 and Visual Studio 2012 since the release of the VS 2012 addin. Today it suddenly stopped working with the error

ERROR 42968 IBM SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968

In the past this has indicated a DB2Connect license issue, so I ran the DB2Licm -l to check if a trial license of some sort had expired and I show the following license information.

C:\Program Files\IBM\SQLLIB\BIN>db2licm -l
Product name: "DB2 Connect Personal Edition"
Product identifier: "db2conpe"
Version information: "10.1"

Other developers who have not upgraded to DS 3.2 and are still using the 9.7 drivers see extra lines indicating license Type & expiry date

C:\Program Files\IBM\SQLLIB\BIN>db2licm -l
Product name: "DB2 Connect Personal Edition"
License Type: "Client Device"
Expiry date "Permanent"
Product identifier: "db2conpe"
Version information: "9.7"

My systems guy is using DS 3.2 but is using the 9.7 license.

What is the correct resolution for this.

This is urgent as I'm unable to make important production changes, so a quick response is appreciated.
Updated on 2013-03-17T12:23:21Z at 2013-03-17T12:23:21Z by rajendrak
  • stoned99
    stoned99
    44 Posts
    ACCEPTED ANSWER

    Re: Visual Studio Add-In stopped working with licensing problem

    ‏2013-03-11T21:35:52Z  in response to stoned99
    Sorry about the double posting, the post button leads to a missing link !!
    • rajendrak
      rajendrak
      40 Posts
      ACCEPTED ANSWER

      Re: Visual Studio Add-In stopped working with licensing problem

      ‏2013-03-12T15:00:35Z  in response to stoned99
      Could you please clarify the following:
      1) Are you using the 'IBM Database Add-Ins for Visual Studio' to connect to DB2?
      2) Could you please provide details on when you get the particular effort? Is it thru Data Studio v3.2?
      3) Also, could you run testconn40 and share the output.
      Ref: http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.swg.im.dbclient.install.doc/doc/r0058814.html

      Regards,
      Raj
      • stoned99
        stoned99
        44 Posts
        ACCEPTED ANSWER

        Re: Visual Studio Add-In stopped working with licensing problem

        ‏2013-03-12T17:01:51Z  in response to rajendrak
        Here's the output from the testconn40 utility and db2cli validate, I actually answered two of you questions in my original post, but for clarity I'll repeat them again.

        I'm using Data Studio 3.2 and the IBM Addin for Visual Studio 2012. Data Studio is working fine, but it does raise the related question is DB2 Connect required to use the Visual Studio Addin ?


        Step 1: Printing version info
        .NET Framework version: 4.0.30319.18034
        DB2 .NET provider version: 9.7.4.4
        DB2 .NET file version: 10.1.2.4
        Capability bits: ALLDEFINED
        Build: s121127
        Factory for invariant name IBM.Data.DB2 verified
        IBM Database Add-ins assembly version: 9.1.0.0
        IBM Database Add-ins file version: 10.1.2.133
        Elapsed: 1.9305405

        Step 2: DB2DSDRIVER_CFG_PATH env var: unset
        Validating db2dsdriver.cfg against db2dsdriver.xsd schema file
        File C:\ProgramData\IBM\DB2\DB2COPY1\cfg\db2dsdriver.cfg missing. Nothi
        ng to validate
        Elapsed: 0.0146475

        Step 3: Connecting using "database=DB2QLOC;server=172.16.1.170:5002;uid=mark;pwd
        =mas123"
        ERROR 42968 IBM SQL1598N An attempt to connect to the database serv
        er failed because of a licensing problem. SQLSTATE=42968

        Test failed.

        C:\Program Files\IBM\SQLLIB\BIN>
        C:\Program Files\IBM\SQLLIB\BIN>
        C:\Program Files\IBM\SQLLIB\BIN>
        C:\Program Files\IBM\SQLLIB\BIN>dir db2ds*
        Volume in drive C has no label.
        Volume Serial Number is A02B-6090

        Directory of C:\Program Files\IBM\SQLLIB\BIN

        11/30/2012 06:31 PM 100,752 db2dsdcfgfill.exe
        1 File(s) 100,752 bytes
        0 Dir(s) 40,060,121,088 bytes free

        C:\Program Files\IBM\SQLLIB\BIN>
        C:\Program Files\IBM\SQLLIB\BIN>db2cli validate
        IBM DATABASE 2 Interactive CLI Sample Program
        (C) COPYRIGHT International Business Machines Corp. 1993,1996
        All Rights Reserved
        Licensed Materials - Property of IBM
        US Government Users Restricted Rights - Use, duplication or
        disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

        CLI Driver Version : 10.01.0000
        CLI Driver Type : IBM Data Server Client
        db2diag.log Path : C:\ProgramData\IBM\DB2\DB2COPY1\DB2\db2diag.log


        IBM Data Server Client packages on the current workstation :

        Copyname Version Installed Location

        DB2COPY1C,D 10.01.0002 C:\Program Files\IBM\SQLLIB



        db2dsdriver.cfg Schema Validation :
        Note: The validation operation utility could not find the
        configuration file named db2dsdriver.cfg.
        The file is searched at C:\ProgramData\IBM\DB2\DB2COPY1\cfg\db2dsdriver.cfg

        The validation completed.
        • rajendrak
          rajendrak
          40 Posts
          ACCEPTED ANSWER

          Re: Visual Studio Add-In stopped working with licensing problem

          ‏2013-03-15T12:31:00Z  in response to stoned99
          • It is very difficult to deduce what might have possibly caused this licensing problem.
          • Since it is urgent, request you to reach out to IBM-Support to have this addressed on priority.

          Regards,
          Raj
          • stoned99
            stoned99
            44 Posts
            ACCEPTED ANSWER

            Re: Visual Studio Add-In stopped working with licensing problem

            ‏2013-03-15T14:19:00Z  in response to rajendrak
            Raj, can you answer this direct question.

            Is a DBConnect license REQUIRED to use the Visual Studio Addin ?
            • rajendrak
              rajendrak
              40 Posts
              ACCEPTED ANSWER

              Re: Visual Studio Add-In stopped working with licensing problem

              ‏2013-03-17T12:23:21Z  in response to stoned99
              Although 'IBM Database Add-In for Visual Studio' comes as a separate installable, most of the functionality is through the .NET data provider which is part of DB2Connect. This is exactly why I had requested you to share the 'testconn' output.

              It seems to be a peculiar issue since your 'licm -l' output indicates it is a valid license but it throws a licensing error through testconn. Since this is a blocking issue and sensing the urgency I would request you to reach out to IBM support, so we could expedite further investigation on this. Also, we would need traces and other artefacts to investigate further which can best be channeled thru IBM-Support.

              Do let me know if you need any help further on this.

              Regards,
              Raj