List companies in a Navision 3.7 c/side database

Johan_van_Bragt

We develop a .NET application that retrieves information using ODBC from a Navision 3.70 database. When i create the DSN to make the ODBC connection i have to specify the company, otherwise i can not create a connection to the database.
In order to specify the company i would like to retrieve a list with the companies that are available in the database and let the user decide to which company he would like to connect.

How can i get a list of the available companies in a c/side Navision 3.70 database.

Sbhat

Hi,

You will have to read the 'Company' table that lists all the companies being used in the database.

Regards
Suresh.