How to execute SQL Stored Procedure from Navision?

Business Central/NAV Developers Forum
1

Folks, Does anyone know how to execute SQL Stored Procedure from Navision[?]? I just curious how to do it. Thanks in advance… Jemmy

2

Hi, I don’t have idea how to execute it from Navision C/AL code but can suggest you alternate way You can create DLL in other languages (e.g. VB), there you can execute Stored Procedure. That DLL you can call it in Navision through Automation.

3

Hi, It is possible through ADO automation.

4

Has found link http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=8753&SearchTerms=ADO,object

5

RAJESH and Anatols, Thanks for your great informations.[:D] I will look forward for the similiar topics on these… Have anyone had experience in the ADO.NET? Jemmy

6

Hi! If you are able to create the proper SQL-Transact-Script (with NAVISION) you could run it with a SHELL command, usig OSQL.EXE ! Regards,