RE: ODBC Datasources

2001-12-07 Thread Dunwiddie, Bruce
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,

RE: ODBC Datasources

2001-12-07 Thread Jeffry Houser
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

RE: ODBC Datasources

2001-12-07 Thread Dunwiddie, Bruce
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

RE: ODBC Datasources

2001-12-06 Thread Dave Watts
Is there an easy way to get a list of ODBC datasources on the server through ColdFusion? Yes. You can use CFREGISTRY to read the HKLM\SOFTWARE\ODBC\ODBC.INI key. If you want native data sources, you can read the appropriate CF registry key. Also, given a datasource, is there a way to get a