Connect Navision SQL Server's database & Visual Basic

upasanisandip

Hi all,
Is it possible to connect Navision SQL Server's database & Visual Basic?
How?

If you have any Hints then also let me know.

Thanks,
Sandip

kriki

[Topic moved from Navision forum to SQL General forum]

A Navision on SQL DB is just a SQL DB. Search for ADO to find how to do it in Visual Basic (best search in the VB-help or a VB-forum)

DenSter

Be careful though, and only use ADO to read from core NAV tables. When you insert/modify records in a NAV database on SQL Server, crucial business logic will not be processed. If you need to integrate with NAV, I suggest you write to staging tables and have a NAV process take it from there, to ensure that business logic is executed.