List companies in a Navision 3.7 c/side database

Johan_van_BragtJohan_van_Bragt Member Posts: 7
edited 2004-04-09 in Navision Attain
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.

Comments

  • SbhatSbhat Member Posts: 301
    Hi,

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

    Regards
    Suresh.
Sign In or Register to comment.