Enumerating ODBC DSN's

Jim W.

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Enumerating ODBC DSN's

I'm trying to write a query utility, much like MSSQL Isql/w or Query
Analyzer, that allows a user to select an ODBC DSN from a listbox or
combobox to establish a connection to a SQL database. Is there a way that I
can enumerate all the ODBC System DSN's on a machine to populate a listbox
either via Delphi functions or through the ODBC API interface from Delphi?

Any help would be greatly appreciated.
Thank you.
jw

Blair Allen Star

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Enumerating ODBC DSN's

If ytou are using Delphi and BDE with Auto-ODBC on. . .

use a tSession and call
tSession.GetAliasNames(List: TStrings);
this gives a list of all ODBC DSN and BDE Aliases

bas

Quote

Jim W. <722332.2...@compuserve.com> wrote in message

news:80ga51$gqg5@forums.borland.com...

Quote

> I'm trying to write a query utility, much like MSSQL Isql/w or Query
> Analyzer, that allows a user to select an ODBC DSN from a listbox or
> combobox to establish a connection to a SQL database. Is there a way that I
> can enumerate all the ODBC System DSN's on a machine to populate a listbox
> either via Delphi functions or through the ODBC API interface from Delphi?

> Any help would be greatly appreciated.
> Thank you.
> jw

jim.stanle

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Enumerating ODBC DSN's

Jim,

I do believe that since Win95, ODBC aliases are stored in the Registry
somewhere. That's where I'd check first.

Jim Stanley
Jacobs Engineering

Other Threads

1. do not to appear ODBC File DSN in the BDE ODBC DSN Combobox

2. Creating 'ODBC System DSN' at runtime

3. Creating 'ODBC System DSN' at runtime

4. Creating 'ODBC System DSN' at runtime

5. InstallShield won't add ODBC DSN to Alias

6. File DSN's for ODBC

7. Retrieving ODBC DSN's

8. BDE Won't Recognize New ODBC DSN

9. User DSN, System DSN or File DSN ?

10. change the odbc dsn in an alias?