List all available Datasources

[filesystem]

Hi@all!

How can I do it, that I get all datasources that are registerd in the
CF-Server?
I tried somethin like that but it did'nt work:

<cfquery datasource="*" name="dbquery">
show databases;
</cfquery>

I hope there is a way because in the CF-Administrator it has ben done in a
way...
Can anyone help me please?

thx

[BKBK]

>... How can I do it, that I get all datasources that are registerd in the
CF-Server?

I shouldn't expect that to be possible, and wouldn't want it either. There
could be
security implications. I expect you can only get the list through the
Coldfusion
Administrator or through RDS. In any case, it would be technically difficult to
obtain the database names in an ordinary cfm page by means of cfml code.
Each datasource may come from a distinct server, may communicate with
Coldfusion via a distinct port and may or may not require its own set of
username and password. The cfquery tag, for example, cannot take all that in.

[filesystem]

hmm I see, I was a littelbit wrong...

But can I for example list the Tables of a known DB?

[BKBK]

>... hmm I see, I was a littelbit wrong...
No, you were not. What you ask for is possible, but not in the way you want.

>... But can I for example list the Tables of a known DB?

Yes, and you can get the list of datasources, but only through CFAdmin.
Try this example. You will find the background information in the
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/00001734.htm[/url].

<cfscript>
adminObj = createObject("component","cfide.adminapi.administr ator");

createObject("component","cfide.adminapi.administr ator").login("your_CFAdmin_Pas
sword");
myObj = createObject("component","cfide.adminapi.datasourc e");
</cfscript>
<cfdump var="#myObj.getDatasources()#">

<!--- NB: The result, myObj.getDatasources(), is a structure --->

[philh]

Depends on the database you're using. Access holds table names in the
MSysObjects table. MS SQL uses INFORMATION_SCHEMA views to return DB object
information. Oracle I'm sure has its own schema query approach.

[BKBK]

>... list of tables IN a known db

MySQL: Run the query, "SHOW TABLES from datasourceName;"

MS SQL: Run the in-built stored procedure, sp_tables, for example
<cfstoredproc procedure="sp_tables" datasource="datasourceName">
<cfprocresult name="tbls">
</cfstoredproc>
<cfdump var="#tbls#">

[Dinghus]

Will this work for Access db?

[BKBK]

>... Will this work for Access db?
I can't say. I hardly use Access. A quick look around, and you will find examples involving schema and [url]http://www.irt.org/script/3006.htm[/url].