You cannot have one DSN for multiple companies.

If you have multiple AdvancePro companies, you would have to manually create DSN for each company database!