| Author |
List available data sources on a local & a network PC
|
Josh Hogan
Greenhorn
Joined: Sep 10, 2010
Posts: 1
|
|
I am trying to build an application for database administrators using java. I am unable to figure out a way to list all installed data sources in the local machine as well as on a network computer. I want the end user to be able to double click the data source and view the database schema. Any ideas? I would really appreciate the help.
Josh
|
 |
Jan Cumps
Bartender
Joined: Dec 20, 2006
Posts: 2343
|
|
Welcome to JavaRanch, Josh.
How would you search for these installed datasources?
|
OCUP UML fundamental
ITIL foundation
|
|
Rob Spoor
Sheriff
Joined: Oct 27, 2005
Posts: 19216
|
|
They're configured in the Windows registry: HKLM\SOFTWARE\OBDC\ODBC.INI\ODBC Data Sources for system DSNs, likewise but in HKCU for user DSNs. The value names are the DSN names.
As for network PCs, you'll need to access the remote registry for that.
|
SCJP 1.4 - SCJP 6 - SCWCD 5
How To Ask Questions How To Answer Questions
|
|
 |
|
|
subject: List available data sources on a local & a network PC
|
|
|
0
