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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Retrieve data from rem...
Microsoft Dynamics GP (Archived)

Retrieve data from remote GP server

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

Hi friends,

                       I want to retrieve entity data from GP SQL server and want to use the data in my visual studio project...GP,GP SQL server and eConnect are installed on a virtual pc..I am working on the base machine..i.e, my project is located on the base machine..The base machine and vpc are connected to the same network...What can I do for retrieving data?..how I can start? ..and which is the best way ?..pls help me by answering these doubts..I am completely new to GP.

*This post is locked for comments

I have the same question (0)
  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

    the base machine is called host. the vpc image inside is called guest.

    do you want online connection from host to guest? or just a 1 time copy of guest sql data?

    online - try  to ping, you have to install SQL in your host and hit the guest sql machine.

    one time copy - back up your data from the guest sql enterprise manager .bak file and drag this file from guest to host maybe on the dektop. now you can restore .bak file into your host sql.

  • hari....software poet Profile Picture
    hari....software poet 660 on at

    Thanks de jesus,

               I want online connection..I have SQL server in host..How can I retrieve data from GP SQL server residing on the guest...can I use econnect?..if I can, how the connection can be specified?

  • Sunbeam De Jesus Profile Picture
    Sunbeam De Jesus on at

    hi,

    i am not sure if you can use econnect, there are members here who are developers, they may can give you a clearer answer. may I know why do you want to use econnect?

    on the other hand, as I have noted you can use SQL enterprise manager to connect online, the first option.

  • hari....software poet Profile Picture
    hari....software poet 660 on at

    Thanks de jesus,

                           I wil not be satisfied with one time copy of SQL data...I want to devolop a web application which takes data from GP,update it and put it back on GP..Can I able to this without eConnect or some other API like eConnect?

  • hari....software poet Profile Picture
    hari....software poet 660 on at

     thanks de jesus,

    pls explain me how to use SQL enterprise manager to connect online..I think that's enough..

     

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    You will need to setup the eConnect Requester Service for which you will need an outgoing message queue -- this means you will need to setup MSMQ on the eConnect/GP server. You can find more infomation on setting up the eConnect Requester Service in the eConnect SDK.

    In the destination machine, where I assume you will have your .NET application, you will need to setup an incoming queue, used to retrieve data from the eConnect MSMQ queue on the other machine. For this you can take a look at my article Retrieving an eConnect XML Message from MSMQ

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

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans