Not available in the Reporter / Desktop Intelligence SDK. Some information is available using the Designer SDK, and you can look at this utility for an example of how to retrieve that information.
Even if you do go the Designer SDK route, I’m not sure it will provide what you are after. For example, it won’t have the database password. I’d be rather upset if it did actually. And from a best practice perspective, the database ID used for the connection should NEVER have anything other than SELECT (read-only) privileges. Honestly, your ADO approach is the best in my opinion.
Dwayne Hoffpauir (BOB member since 2002-09-19)