Way to get a list of accpac dbs and MS SQL dbs?

[XJ900]

Is there a way to get a list of all the company databases and their MS SQL names using VB or is there a file accpac saves this information to?

 

[ettienne]

Yes, the information is stored in Orgs.ism
Login to a company and open the AS0020 view, you can get all company information there.

 

[XJ900]

Thanks, that is exactly what I am looking for!

 

[XJ900]

On another note, I am wondering if anyone can tell me how to use the AccpacOrganizations object? Along the above lines I'd like some way to return the SQL database name of the company I'm in.

Thanks

 

[ettienne]

AccpacOrganizations does not return the SQL database name.
Look at DATABASE in AS0020, the format is something like SERVER..DATABASE for SQL databases.

 

[XJ900]

OK thanks.