ADO and NAS with Nav 6.0

ajaybabuCh
Member Posts: 208
Hi
I have a scenario presently using with Navision 5.0.
Scenario is, I am using ADO to connect to SQL database from navision.
My codeunit will read the data from SQL tables through ADO and creates the Purchase Orders and post them. I am using NAS to automate this process.
Can I use the same procedure explained above with Navision 6.0 role based client.
What is the best strategy to implement the above process other than ADO and NAS.
Thanks
Ajay
I have a scenario presently using with Navision 5.0.
Scenario is, I am using ADO to connect to SQL database from navision.
My codeunit will read the data from SQL tables through ADO and creates the Purchase Orders and post them. I am using NAS to automate this process.
Can I use the same procedure explained above with Navision 6.0 role based client.
What is the best strategy to implement the above process other than ADO and NAS.
Thanks
Ajay
Ajay
0
Comments
-
Yes, the part regarding NAS is same in NAV 6.0 (NAV 2009) like in NAV 5.0... there is no replacement for NAS in NAV 2009 (for running some automatic tasks)...0
-
thaks for the information.
Is there any other alternative for this process other than ADO.
What about CFront? can we call and run a codeunit from Cfront?Ajay0 -
1) C/Front is for accessing NAV database. It cannot run any business logic
2) What you described is, that you are accessing SQL table from NAV, C/Front is for the oposite direction, accessing NAV from outside
3) You can use WebServices for that, that the application, which is now writing the data into the table on remote server, will instead call the WebService you will made in NAV and pass the data into it. Than you can process the data within NAV with C/AL code and if there is some error, the WebService will return this error to the calling application...0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions