enigment wrote:
Is there any way in open db to get info on all the defined datasources? This is for an ad hoc query tool, and what I need is the name, and ideally the db type and version, or lacking that, driver name.
You can do this by leveraging the administrator code. We're going to be reworking the admin API on the next release of the administrator to make things like this more straightforward, but for now you can do this on a CFML page:
<cfapplication name="OpenBDAdminConsole" sessionmanagement="true" />
<cfset session.auth.password = "your_admin_password" />
<cfset session.auth.loggedIn = true />
<cfset ds = CreateObject("component", "bluedragon.adminapi.Datasource") />
<cfdump var='#ds.getDatasources()#' />
ds.getDatasources() will give you an array of structs containing all the
datasource settings.
Or of course you can just read the XML config file directly if you'd prefer. -- Matthew Woodward [email protected] http://www.mattwoodward.com/blogPlease do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments.
http://www.gnu.org/philosophy/no-word-attachments.html
smime.p7s
Description: S/MIME Cryptographic Signature
