<!--- Get "factory" --->
<CFOBJECT ACTION=""> TYPE="JAVA"
CLASS="coldfusion.server.ServiceFactory"
NAME="factory">
<!--- Get datasource service --->
<CFSET dsService=factory.getDataSourceService()>
<!--- Get datasources --->
<CFSET dsFull=dsService.getDatasources()>
<!--- Extract names into an array --->
<CFSET dsNames=StructKeyArray(dsFull)>
<!--- List names --->
<UL>
<CFLOOP INDEX="i"
FROM="1"
TO="#ArrayLen(dsNames)#">
<!--- Display name --->
<CFOUTPUT>
<LI>#dsNames[i]#</LI>
</CFOUTPUT>
</CFLOOP>
</UL>
On Wed, 24 Mar 2004 09:12:58 +0100 (CET), Jochem van Dieten wrote:
> john cesta said:
>>
>> In cf50 even though you didn't add the DB thru the cf admin the cf
>> admin would still list it. I see that in CFMX it doesn't list it
>> if
>> you don't add it thru the cfadmin.
>>
>> I am building a new cfmx server and haven't tried this yet but
>> will
>> DBs added thru the ODBC control panel or just added into the
>> registry via automation still work in a CFMX query?
>
> No.
>
>> PS: Please don't tell me I am going to have to write automation to
>> create all those xml files.
>
> If you tell which dbms you are using somebody on the list might have
> some work done already.
>
> While you are at it, you should investigate doing away with ODBC
> alltogether. With CF MX based in Java JDBC is the native way to
> connect to databases, and if a native JDBC driver is available using
> that is much prefered.
>
> Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
