OK I found the function CFusion_GetODBCDSN which is
supposed to return the datasource names from the
coldfusion administrator
the oreilly book gives the example of
<cfset Thedatasourcenames=CFusion_GetODBCDSN()>
<table>
<tr><th>Name</th><TH>Description</TH></tr>
<cfoutput query="Thedatasourcenames">
<TR><td>#Name#</td><TD>#Description#</TD></TR>
</cfoutput>
</table>
but it does not return anything
what am I missing?
--- "Stephen Moretti (cfmaster)"
<[EMAIL PROTECTED]> wrote:
> William Kossack wrote:
>
> >we are using CF 5
> >
> >it is a dedicated server
> >
> >
> OK - cool.
>
> In that case, CF stores ODBC entries under a
> registry key under the
> Allaire key in
> HKEY_LOCAL_MACHINE/SOFTWARE/Allaire/Coldfusion
>
> Of course typically I can't get to the registry for
> a CF5 server at the
> minute, otherwise I'd tell you the exact keys.
>
> You can use the CFRegistry tag to pick up the
> appropriate registry keys
> and drag them into a query object that you can then
> work your way
> through. ODBC entries are also stored in the
> registry
> (HKEY_LOCAL_MACHINE/SOFTWARE/ODBC), so you could get
> to them that way as
> well.
>
> I believe there is an undocumented CF5 tag that you
> could use too, but
> I'm afraid that it has slipped my mind at this time.
>
> Hope this helps
>
> Regards
>
> Stephen
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=35
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:430
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
