web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / How To Connect To GP
Microsoft Dynamics GP (Archived)

How To Connect To GP

(0) ShareShare
ReportReport
Posted on by hari....software poet 660

Hi, Friends..

               I had started a visual studio web application  project...I want to connect my project to Great Plains database..I want to move data from gp to my project and vice versa,,How it is possible? pls help me....

*This post is locked for comments

I have the same question (0)
  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at
    Re: How To Connect To GP

     Hi,

      Econnect is the best integration tool for .net application. Using this you insert and retrieve  data from GP.

    Regards

    Jeganeedhi

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: How To Connect To GP

    Thanks, Jaganeedhi,

                How I can use econnect?...Can I add GP as a service reference in my vs project?...Is it possible?..I don't have any knowledge about econnect..Pls explain me..

     

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at
    Re: Re: Re: How To Connect To GP

     hari,

              First you need to install eConnect. Then you can get the .Net Objects in eConnect installation folder.

    add that dll to your .Net application. And refer the programmers guide for how to write the .net code for econnect.

    Also sample application and help files also available in installation folder.

    Regards

    Jeganeedhi

     

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: Re: Re: How To Connect To GP

    Thanks, jeganeedhi,

                       But GP is located on a virtual pc.. econnect is already installed on the vpc...My vs project is located on the base machine...How can I add reference from vpc to the base machine project?..Base machine and vpc are connected to same network...

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at
    Re: Re: Re: Re: Re: How To Connect To GP

    Hari,

     Install eConnect in ur machine. No need to install GP in your system. Otherwise copy dll from that vpc to your machine.

    And add the reference.

     

    Regards

    Jeganeedhi

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: Re: Re: Re: Re: How To Connect To GP

    Thanks Jagan,

                    I started writing code for econnect..But an exception arises in the following line

    eConnectMethods eConnectObject = new eConnectMethods();

     

     The exception is " you must have administrative credentials to perform this task"..Why this happen?

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Re: Re: How To Connect To GP

    Hari, any luck solving this issue?

  • sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at
    Re: Re: Re: Re: Re: Re: How To Connect To GP

    Hari/Joseph,

    First check your service for eConnect (in and out) is running or not. Second please add "windows" user account in SQL and assign Dynamics and production DB company and check eConnect application is working for you or not.

    I will recommend to go for Dynamics GP Webservice cause eConnect you have to install on each client machine who is going to use your eConnect application where as maintaining Webservice and user account is very easy in Dynamics GP web service.

    Thanks

    Sandip Jadhav

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Re: Re: How To Connect To GP

    Thanks for your quick response!

    I am using the .Net eConnect dll in a Windows Form application.  I have no problem using it logged on as an admin.  The problem occurs when a domain user is logged on.

    The admin account is not in the database.  I believe the issue resides in the DTC settings.  I will continue to research.   Any advice would be greatly appreciated.

    Thank you.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans