<cfquery name="gettablenames" datasource="#somedsn#" dbtype="odbc">
select name
from sysobjects
where xtype='U'
</cfquery>
-----Original Message-----
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 07, 2001 11:18 AM
To: CF-Talk
Subject: RE: ODBC Datasources
The tables in a datasource are stored in the registry?
At 10:52 AM 12/07/2001 -0600, you wrote:
>you have to read the registry for both. gl.
>
>-----Original Message-----
>From: tom muck [mailto:[EMAIL PROTECTED]]
>Sent: Thursday, December 06, 2001 11:49 AM
>To: CF-Talk
>Subject: ODBC Datasources
>
>
>Is there an easy way to get a list of ODBC datasources on the server
through
>ColdFusion? Also, given a datasource, is there a way to get a list of
>tables from that datasource?
>
>tom
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
