ODBC Multiple Companies

When I use ODBC to extract information from Navision I have to sign into one of our four companies. I have the same username/password for all four companies, and in Navision I can switch companies in the File meny. I would like to be able to access all 4 through the same ODBC link. How to a do that.

Setup a new data source for your database and leave the field “Company” of the setup dialog blank. You will be prompted for the company to choose when you connect via ODBC.