Access external database (SQL)

Business Central/NAV Developers Forum
1

Hi, We have our own VB application running in SQL server. We need to access some of the tables (external database) into Navision GL. Can some one guide me how to go about it? Is it possible to use DSN to access external database in Navision? Thanks & Regards

2

hi Aanandan, yes, you can use system dsn to access sql server into navision by using ado.

3

Thanks

4

Hi, For Table access Make a DSN , Write code similar as VB make Database connection make a Recordset with Connection Open table and try to fire query as per required. Bye