aspose file tools*
The moose likes JDBC and the fly likes List available data sources on a local & a network PC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "List available data sources on a local & a network PC" Watch "List available data sources on a local & a network PC" New topic
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: 2510
    
  10

Welcome to JavaRanch, Josh.

How would you search for these installed datasources?

OCUP UML fundamental and ITIL foundation
youtube channel
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19762
    
  20

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 - OCEEJBD 6
How To Ask Questions How To Answer Questions
 
Consider Paul's rocket mass heater.
 
subject: List available data sources on a local & a network PC