Access external database (SQL)

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

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

Thanks

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