Open Forum

Expand all | Collapse all

Missing GPConnNet.dll dependency with V18

  • 1.  Missing GPConnNet.dll dependency with V18

    GOLD CONTRIBUTOR
    Posted Jul 19, 2021 03:53 PM
    Hello all,

    Spoiler alert -> This one is very technical.

    If I create a standalone application which is being deployed on machines where Dynamics GP is NOT deployed, I cannot use the earliest version of GPConnNet.dll.
    My version is actually 18.0.10.0 which is the one for GP2018 SP2.

    When I deploy my executable on a machine where GP is not installed, I receive :
    "Could not load file or assembly GPConnNet.dll or one of its dependencies."

    What is very strange is if I replace the GPConnNet v18 by the old version 12 I had for GP2013, everything works fine.

    Anyone would know what I need to deploy as missing dependency, or I can I know what is this dependency that is missing ?

    Thanks !

    ------------------------------
    Luc St-Yves, Senior Business Analyst
    Humanware Technologies, QC (Canada)
    Implementation projects leader
    -Essilor Instruments USA and Canada
    -Essilor International S.A.S., France
    --Promoting Dynamics GP in Europe--
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Missing GPConnNet.dll dependency with V18

    TOP CONTRIBUTOR
    Posted Jul 19, 2021 04:44 PM
    This is for using GP Encrypted Passwords in your .NET integration right? Have you installed Microsoft Shared\Dexterity components\vX.X  and added the correct reference to the GPConnNet.dll into your Visual Studio application?




    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Missing GPConnNet.dll dependency with V18

    GOLD CONTRIBUTOR
    Posted Jul 19, 2021 05:44 PM
    Hello Thaddeus,
    Yes this is for GP encrypted password.
    as I mentioned, I compile with the .dll so yes, it is included.
    Indeed, when using the V12 of GPConnNet.dll, it works perfectly.

    I have not installed Microsoft Shared components and would like to avoid.  Since this development can be on machines that I have no control on, I would like my app to simply works stand alone, just by installing, but I need GPConnNet since I am authenticating my users with their GP password to open SQL connections.

    ------------------------------
    Luc St-Yves, Senior Business Analyst
    Humanware Technologies, QC (Canada)
    Implementation projects leader
    -Essilor Instruments USA and Canada
    -Essilor International S.A.S., France
    --Promoting Dynamics GP in Europe--
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 4.  RE: Missing GPConnNet.dll dependency with V18

    TOP CONTRIBUTOR
    Posted Jul 19, 2021 06:04 PM
    For the GP Encrypted passwords to work, I believe you will need the dexterity shared components installed appropriate to the GPConnNet.dll version. If you are in Visual Studio, the dll will require a reference to the same version in the dexterity shared components location Your project may still be referencing a local copy from the other GP version. You want to point the reference to use the new GPConnNet.dll
    If it is not installed and thus in the registry I think you will have the problem.
    You won't need a GP client but I would test by installing the dexterity shared components to verify.

    David Musgrave will likely know and possibly he will see this post.


    ------------------------------
    Thaddeus Suter
    Retus, Inc
    HELOTES TX
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 5.  RE: Missing GPConnNet.dll dependency with V18

    GPUG ALL STAR
    Posted Jul 20, 2021 02:06 AM

    Hi Thaddeus and Luc

    Obviously it would be nice if the correct version deployed with GP can be used and works, but as long as you get it working that is good.

    I have never needed to use this functionality as I have always worked inside GP using Dexterity and/or VSTools addins where I can leverage GP's existing connections.

    Regards

    David



    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 6.  RE: Missing GPConnNet.dll dependency with V18

    TOP CONTRIBUTOR
    Posted Jul 20, 2021 09:53 AM
    Hi Luc,

    Can you ditch GPConnNet.dll and just connecting to SQL directly?  I do that all of the time in a bunch of C# apps where I query GP's data.  I have a few Active Directory (AD) groups (with the appropriate AD users) setup in SQL.  I always access the database via my stored procedures.  I give each AD group access to the necessary stored procedures.  It does require you to keep two sets of security - one in GP and one in AD.  I've been doing this for over 10 years and it has been working great.

    Hint: prefix your stored procedures with something like "_hwg_TableSelect"   The initial _ will make your stored procedure appear before the thousands of GP supplied stored procedures and the hwg_ will let you know it's yours (HumanWare Group).

    Good Luck!  If you have any questions, feel free to give me a yell!

    ------------------------------
    John Arnold
    Senior Software Engineer
    US Digital
    Vancouver WA
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 7.  RE: Missing GPConnNet.dll dependency with V18

    GOLD CONTRIBUTOR
    Posted Jul 20, 2021 10:40 AM
    Thank you John, yes I can use my own SQL Logins and get rid of GPConnNet, but the purpose here is to have a development, outside of GP, which starts by creating SQL connections from a login screen which I have the user enters his creds.  This way, I make sure the user has a valid access to GP and also, I make sure I uses its SQL access to the different companies he has access to...

    Anyhow, thanks for the tip.

    ------------------------------
    Luc St-Yves, Senior Business Analyst
    Humanware Technologies, QC (Canada)
    Implementation projects leader
    -Essilor Instruments USA and Canada
    -Essilor International S.A.S., France
    --Promoting Dynamics GP in Europe--
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 8.  RE: Missing GPConnNet.dll dependency with V18

    GOLD CONTRIBUTOR
    Posted Jul 21, 2021 09:00 AM
    Just to let you know of my findings...

    Thaddeus was right, to be able to use the GPConnNet.dll v18 requires simply to install Dexterity components, which requires .Net framework 3.5

    This was not the case with older version of GPConnNet, it is now.
    Probably it is including a .dll from the GAC.

    Cheers all !

    ------------------------------
    Luc St-Yves, Senior Business Analyst
    Humanware Technologies, QC (Canada)
    Implementation projects leader
    -Essilor Instruments USA and Canada
    -Essilor International S.A.S., France
    --Promoting Dynamics GP in Europe--
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role