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) / Connection to GP
Microsoft Dynamics GP (Archived)

Connection to GP

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

Hi friends,

           I want to move data between my visual studio project and GP...GP is located on a virtual pc and my project is on the base machine..I had added three econnect dll references to my project..How I can start the coding with econnect by providing a username,password,server name and database name?..I am completely new to econnect and GP..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: Connection to GP

     Hari,

     Econnect requires windows athentication.Better you refer the eConnect samples in installation folder

    regards

    Jeganeedhi

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: Connection to GP

    Thanks Jeganeedhi,

                                  How can I pass username,password,server and database parameters to econnect?

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at
    Re: Re: Re: Connection to GP

     Hari,

    In eConnect entry point we need to pass connection string. That is windows authentication. It looks like

    ConnectionString = @”data source=SERVERNAME;initial catalog=DBNAME;integrated security=SSPI;persist security info=False;packet size=4096;enlist=false”

     

    Regards

    Jeganee

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: Re: Re: Connection to GP

     Thaks,

     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?

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: Re: Re: Re: Connection to GP

    And, one more doubt

                        In order to login, GP in virtual pc needs username and password..How I can pass these two from my project?

  • Jeganeedhi Krishnan Profile Picture
    Jeganeedhi Krishnan 2,500 on at
    Re: Re: Re: Re: Re: Re: Connection to GP

     Hari,

     

    Can u able  connect the GP SQL server from ur pc?

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: Re: Re: Re: Re: Re: Connection to GP

    No, how it is possible?..I actually needs entity data from GP....GP SQL server is located on vpc

  • hari....software poet Profile Picture
    hari....software poet 660 on at
    Re: Re: Re: Re: Re: Re: Re: Re: Connection to GP

    SQL server did not need a username and password..it uses windows authentication..that means, in order to connect and retrieve data from GP , no need to pass username and password..Am I correct?

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