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) / Question on setting up...
Microsoft Dynamics GP (Archived)

Question on setting up eConnect and SQL

(0) ShareShare
ReportReport
Posted on by WarrenWSav 490

Hello,

I am trying to learn about how econnect and sql works. I assume in econnect I have to enter the sql connection info so it can access it. The SQL I wanted to use is on a hosted server which I can access through management studio. So it accepts remote connections. So would this work? Or are there other requirements that may keep me from using that sql that I won't be able to change?

Thanks,

Warren

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at

    No brief answer could simply fulfill the need of your question. Therefore, I would recommend to check the reference posted previously MS Dynamics World, which is a series of Three Articles covering this issue. Your specific point might be found of the third article regarding SQL.

    Creating a Microsoft Dynamics GP Integration with eConnect and a SQL Stored Procedure

    1. Part One
    2. Part Two
    3. Part Three
    Hope this helps, 
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Here are some full fledged examples.  

    www.sanjaykumar.us/.../econnect-project-references

    www.sanjaykumar.us/.../econnect-getnextdocnumbers-class-vb-net-example

    www.sanjaykumar.us/.../e-connect-sop-hold-vb-net-examples

    www.sanjaykumar.us/.../dynamics-gp-econnect-create-journal-entry-vb-net-example

    www.sanjaykumar.us/.../dynamics-gp-econnect-create-customer-parent-id-vb-net-example

    www.sanjaykumar.us/.../econnect-customer-address-internet-info

    www.sanjaykumar.us/.../econnect-customer-address-example

    If you have any integration in mind post it here, couple of examples can be added too!

    Cheers

    Sanjay

  • Warren Williams Profile Picture
    Warren Williams on at

    Thanks everyone for the replies and links. I have been going though and reading them and learning more as well. I guess my issue is this. I saw screens for setting up the sql server for when you install econnect and it prompted for the type of connection and the server name, etc. But I was told that when I actually use econnect in my .NET code that the connection between the econnect and the sql server must be trusted. They said I cannot use a login for the sql connection. Is this true?

    Then I saw where I could install this web service to use between econnect and the sql server. Maybe I can add the sql connection string with the login in it and it will work. I won't get a chance to try until next week. Anyone know about this?

    Thanks!

    Warren

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Dim _SQLConnectionString = "data source=[SQLSERVER];initial catalog=[COMPANY DB];integrated security=SSPI; persist security info=False;packet size=4096"

    Cheers!

    Sanjay

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
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans