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 NAV (Archived) / integration between sq...
Microsoft Dynamics NAV (Archived)

integration between sql server 2005 and microsoft access inventory to asyncronus update data

(0) ShareShare
ReportReport
Posted on by ahmed barbary 4,548

I have microsoft dynamic nav 2009 r2 connected to sql server 2005 .when supplier support us with raw material  we take weight of this raw material before it put in inventory and which vendor and all data by program connected to weight bridge and computer and connected with microsoft access this for first time and second day we take same data and input this data inside dynamic nav 2009r2 meaning we made same processes two time .are any way or solution avalable

to integrate and asyncronus data found in access with microsoft sql server 2005 although the data register here is same second data register in dynamic because i want to know inventory raw material in same momment and input data two time will make uncorrect user input in some times

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at

    Hi

    I assume from your message that you are a developer, if you are an end user I would suggest getting your NAV partner to assist here

    Yes definitely possible, what I would suggest doing is using the Linked Server functionality to connect the Access database to the SQL server, then you will be able to create Queries to that database in SQL and make those queries available as linked tables in NAV

    The idea being that you will then be able to fetch information directly from that system's access database as your code runs in NAV

    You can find information on how to link the DB to SQL here

    www.techrepublic.com/.../133

    And how to create the linked table from the query in NAV here

    dynamicsuser.net/.../how-to-display-an-sql-server-view-in-microsoft-dynamics-nav.aspx

    Hope this helps

  • ahmed barbary Profile Picture
    ahmed barbary 4,548 on at

    OK good  first i m developer  your answer is very good.i have another idea but i don't know how to implement this can i join weight bridge with dynamic nav direct by serial port  if this possible can you give me code unit

  • nChannel Profile Picture
    nChannel 370 on at

    Not sure but you may need an integration solution for NAV and your inventory system? Our NAV connector can help with inventory sync as well as connecting your Microsoft ERP system to a number of Point of Sale, eCommerce, 3PL or remote warehouse systems. www.nchannel.com/connect-microsoft-dynamics-nav

    If you have any questions or would like to talk more in detail and if our solution can help, feel free to contact us at any time.

    Darren

    info@nChannel.com

  • Suggested answer
    Neville Foyn Profile Picture
    Neville Foyn 4,320 on at

    Hi

    It would be possible as NAV is able to use dot net components in NAV 2009 and dot net allows serial port communication, i haven't done it myself so don't have ready code

    There are two main issues to overcome, the first is the actual communication with the port and the second is saying the right things to the bridge and understanding the replies

    Below is how it is done in VB however you will need to do the conversion to NAV (Something that is a lot harder than it sounds in my experience normally taking hours of trial and error)

    support.microsoft.com/.../823179

    Alternatively you can look at what others have done using custom controls however the newer versions of NAV no longer use OCX controls so some of these solutions will no longer work

    www.google.com.au/search

    My suggestion is that if you have a several sites it is worth the time investment, if not rather use the linked tables

    Let us know how it goes

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 NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans