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,
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
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
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
4 matches
Mail list logo