Please I have a Weighbridge that has a Microsoft Access database that I will like to integrate with AX 2012.
I need the inform from the Access database for use by AX 2012.
Please how can I achieve this.
Please refer to thread with similar question community.dynamics.com/.../165264
Thanks can I get a better guide.
You did not understand something from that thread or what is your question ?
I want the AX 2012 to retrieve data from Access Database. I want the integration to be in such a way that the Truck Weight IN and Out that has been captured in the Weighbridge software(Access) will be automatically be filled in when the user just select the Track Number in AX 2012.
Thanks for the explanation.
What kind of help do you require ?
You don't know how to connect to Access or how to retrieve data or you don't understand how to build whole solution ?
I know that I can use ODBC for connection but I need to know why to build a whole Solution.
I just need a manual on how to do this
1) Create a class that will connect to Access DB and select truck weight by track id jkmsdax2012.wordpress.com/.../external-database-or-odbc-connection-in-ax-2012 as example.
2) Add code that will call class from 1. when user modifies track id to get required values and populate them to required fields.
It's hard to provide any details because I have no idea how Weighbridge software looks like, what tables it has and what data you need to select or what form you are referring to when you are talking about truck id.
Please see one of the .mdb files one want to integrate with AX2012, kindly assist with the steps to integrate it with AX 2012,
I have the same requirement. I have collected some information from web related to creating new DSN 32bit, at configuring it will act as a Client for the Weighbridge Software. Next we should communication port details of Weighbridge Software like Example below:
There our required fields are mainly Weights i.e. Gross, Tare and Net(calculated)
At AX, We shall program like such :
Pretty sure, we can achieve this !
Shobhit, using COM ports is a very different approach than using ODBC. But if you go that way, you can use SerialPort class.
Absolutely Martin I agree.