Need to work out which database name is associated with a specific datasource.
Do not have access to:
web administrator
or a password for <cfadmin>
At first I thought <CFDBINFO> would be the ticket But it appears it will only give me the list of databases available via the datasource, but not which of the visible databases the datasource is bound to.
For example; the database the datasource is bound to here is stage_boxofbooks but there does not appear to be anyway to tell this programmatically.
Firstly, a datasource does not require that a database be set. It can be left empty and will end up pointing the default database for the login (at least in SQL Server). If you are ok with some server-specific syntax (and your DB supports it), you can just do a cfquery with this (SQL Server shown)
Thanks for that. I was hoping for a DB agnostic approach. Might make a worthwhile enhancement to <CFDBINFO> ā just wish i understood why its not there in the first place.