File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and Relational Databases 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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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: 2541
    
  10

Welcome to JavaRanch, Josh.

How would you search for these installed datasources?

OCUP UML fundamental and ITIL foundation
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 20048
    
  30

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 - OCEJPAD 6
How To Ask Questions How To Answer Questions
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: List available data sources on a local & a network PC
 
It's not a secret anymore!