db2 connect

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Steve Smith

    db2 connect

    I have just installed db2 connect v8.1 (personal edition) on my PC - and
    reinstalled DB2 Application development client (again v8.1 FP4). When trying
    to use this to connect via CLI to an AS/400 (which is set up correctly
    according to the 'DB2 Version 8 Connectivity Cheat sheet' by Raul F Chong) I
    get an error message from db2licm.exe telling me that 'The procedure entry
    point sqlofgets could not be located in the dynamic link library
    DB2SYS.dll'.

    Does anyone know what this means - or how to fix it please ?

    Steve S


  • Larry

    #2
    Re: db2 connect

    Sounds like some part of the install didn't complete successfully. Post
    error msg #.

    Also, is it possible that the A/D client is at fp4, but DB2 Connect is not?

    Larry Edelstein

    Steve Smith wrote:[color=blue]
    > I have just installed db2 connect v8.1 (personal edition) on my PC - and
    > reinstalled DB2 Application development client (again v8.1 FP4). When trying
    > to use this to connect via CLI to an AS/400 (which is set up correctly
    > according to the 'DB2 Version 8 Connectivity Cheat sheet' by Raul F Chong) I
    > get an error message from db2licm.exe telling me that 'The procedure entry
    > point sqlofgets could not be located in the dynamic link library
    > DB2SYS.dll'.
    >
    > Does anyone know what this means - or how to fix it please ?
    >
    > Steve S
    >
    >[/color]

    Comment

    • Steve Smith

      #3
      Re: db2 connect

      Larry,

      I didn't get any error messages during the install. The first thing I get
      when trying to 'connect' is a window (with 'db2bp.exe - Entry Point not
      found' header and the error message as listed below (no error message no).
      When I OK that (only option), I get
      SQL8002N Connect processing failed; a valid product license was not found.
      SQLSTATE=42968

      This is exactly the same message I was getting when trying to connect to an
      AS/400 before installing DB2 connect.

      Wrt versions, I downloaded db2 connect from an IBM web site - but am having
      some difficulty now finding where I got it from (part of the PWD site I
      think). Can I tell somehow what version I have ?

      Regards

      Steve

      "Larry" <larry@nospam.n et> wrote in message
      news:cC9Qb.6026 $O22.1560233@ne ws4.srv.hcvlny. cv.net...[color=blue]
      > Sounds like some part of the install didn't complete successfully. Post
      > error msg #.
      >
      > Also, is it possible that the A/D client is at fp4, but DB2 Connect is[/color]
      not?[color=blue]
      >
      > Larry Edelstein
      >
      > Steve Smith wrote:[color=green]
      > > I have just installed db2 connect v8.1 (personal edition) on my PC - and
      > > reinstalled DB2 Application development client (again v8.1 FP4). When[/color][/color]
      trying[color=blue][color=green]
      > > to use this to connect via CLI to an AS/400 (which is set up correctly
      > > according to the 'DB2 Version 8 Connectivity Cheat sheet' by Raul F[/color][/color]
      Chong) I[color=blue][color=green]
      > > get an error message from db2licm.exe telling me that 'The procedure[/color][/color]
      entry[color=blue][color=green]
      > > point sqlofgets could not be located in the dynamic link library
      > > DB2SYS.dll'.
      > >
      > > Does anyone know what this means - or how to fix it please ?
      > >
      > > Steve S
      > >
      > >[/color]
      >[/color]


      Comment

      • Larry

        #4
        Re: db2 connect

        Not sure of exactly what to make of this. The "Entry Point Not Found"
        sounds like something didn't install completely. But I believe the
        sql8002n means that a try-and-buy license expired. You may need to open
        a PMR unless someone else has any suggestions.

        Larry Edelstein

        Steve Smith wrote:[color=blue]
        > Larry,
        >
        > I didn't get any error messages during the install. The first thing I get
        > when trying to 'connect' is a window (with 'db2bp.exe - Entry Point not
        > found' header and the error message as listed below (no error message no).
        > When I OK that (only option), I get
        > SQL8002N Connect processing failed; a valid product license was not found.
        > SQLSTATE=42968
        >
        > This is exactly the same message I was getting when trying to connect to an
        > AS/400 before installing DB2 connect.
        >
        > Wrt versions, I downloaded db2 connect from an IBM web site - but am having
        > some difficulty now finding where I got it from (part of the PWD site I
        > think). Can I tell somehow what version I have ?
        >
        > Regards
        >
        > Steve
        >
        > "Larry" <larry@nospam.n et> wrote in message
        > news:cC9Qb.6026 $O22.1560233@ne ws4.srv.hcvlny. cv.net...
        >[color=green]
        >>Sounds like some part of the install didn't complete successfully. Post
        >>error msg #.
        >>
        >>Also, is it possible that the A/D client is at fp4, but DB2 Connect is[/color]
        >
        > not?
        >[color=green]
        >>Larry Edelstein
        >>
        >>Steve Smith wrote:
        >>[color=darkred]
        >>>I have just installed db2 connect v8.1 (personal edition) on my PC - and
        >>>reinstalle d DB2 Application development client (again v8.1 FP4). When[/color][/color]
        >
        > trying
        >[color=green][color=darkred]
        >>>to use this to connect via CLI to an AS/400 (which is set up correctly
        >>>according to the 'DB2 Version 8 Connectivity Cheat sheet' by Raul F[/color][/color]
        >
        > Chong) I
        >[color=green][color=darkred]
        >>>get an error message from db2licm.exe telling me that 'The procedure[/color][/color]
        >
        > entry
        >[color=green][color=darkred]
        >>>point sqlofgets could not be located in the dynamic link library
        >>>DB2SYS.dll '.
        >>>
        >>>Does anyone know what this means - or how to fix it please ?
        >>>
        >>>Steve S
        >>>
        >>>[/color]
        >>[/color]
        >
        >[/color]

        Comment

        • Steve Smith

          #5
          Re: db2 connect

          Larry (and all)

          I have got this resolved via a PMR now. The basic problem was that I assumed
          I needed to install DB2 Connect aswell as the FP4 version of the App Dev
          Client - whereas all I really needed to do was a custom install using the
          DB2 COnnect v8.1 FP4 software - making sure I included all of the client
          apps I wanted.

          Thanks for your help.

          Regards
          Steve

          "Larry" <larry@nospam.n et> wrote in message
          news:SPdQb.7671 $O22.2461060@ne ws4.srv.hcvlny. cv.net...[color=blue]
          > Not sure of exactly what to make of this. The "Entry Point Not Found"
          > sounds like something didn't install completely. But I believe the
          > sql8002n means that a try-and-buy license expired. You may need to open
          > a PMR unless someone else has any suggestions.
          >
          > Larry Edelstein
          >
          > Steve Smith wrote:[color=green]
          > > Larry,
          > >
          > > I didn't get any error messages during the install. The first thing I[/color][/color]
          get[color=blue][color=green]
          > > when trying to 'connect' is a window (with 'db2bp.exe - Entry Point not
          > > found' header and the error message as listed below (no error message[/color][/color]
          no).[color=blue][color=green]
          > > When I OK that (only option), I get
          > > SQL8002N Connect processing failed; a valid product license was not[/color][/color]
          found.[color=blue][color=green]
          > > SQLSTATE=42968
          > >
          > > This is exactly the same message I was getting when trying to connect to[/color][/color]
          an[color=blue][color=green]
          > > AS/400 before installing DB2 connect.
          > >
          > > Wrt versions, I downloaded db2 connect from an IBM web site - but am[/color][/color]
          having[color=blue][color=green]
          > > some difficulty now finding where I got it from (part of the PWD site I
          > > think). Can I tell somehow what version I have ?
          > >
          > > Regards
          > >
          > > Steve
          > >
          > > "Larry" <larry@nospam.n et> wrote in message
          > > news:cC9Qb.6026 $O22.1560233@ne ws4.srv.hcvlny. cv.net...
          > >[color=darkred]
          > >>Sounds like some part of the install didn't complete successfully. Post
          > >>error msg #.
          > >>
          > >>Also, is it possible that the A/D client is at fp4, but DB2 Connect is[/color]
          > >
          > > not?
          > >[color=darkred]
          > >>Larry Edelstein
          > >>
          > >>Steve Smith wrote:
          > >>
          > >>>I have just installed db2 connect v8.1 (personal edition) on my PC -[/color][/color][/color]
          and[color=blue][color=green][color=darkred]
          > >>>reinstalle d DB2 Application development client (again v8.1 FP4). When[/color]
          > >
          > > trying
          > >[color=darkred]
          > >>>to use this to connect via CLI to an AS/400 (which is set up correctly
          > >>>according to the 'DB2 Version 8 Connectivity Cheat sheet' by Raul F[/color]
          > >
          > > Chong) I
          > >[color=darkred]
          > >>>get an error message from db2licm.exe telling me that 'The procedure[/color]
          > >
          > > entry
          > >[color=darkred]
          > >>>point sqlofgets could not be located in the dynamic link library
          > >>>DB2SYS.dll '.
          > >>>
          > >>>Does anyone know what this means - or how to fix it please ?
          > >>>
          > >>>Steve S
          > >>>
          > >>>
          > >>[/color]
          > >
          > >[/color]
          >[/color]


          Comment

          Working...