File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes file,system,user dsn Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "file,system,user dsn" Watch "file,system,user dsn" New topic

file,system,user dsn

sushant prabhu
Ranch Hand

Joined: Mar 22, 2001
Posts: 66
In ODBC what is the differnce between file , system and user dsn.

Sushant Prabhu<br />SCJP2<br />SCWCD<br />OCA9i
Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
File DSN's are for connecting to files as datasources. For example, an ASCII text file.
System DSN's are available to all users of a given system and can point to a variety of data sources.
User DSN's are available only to specific users and can point to a variety of data sources.
I agree. Here's the link:
subject: file,system,user dsn
It's not a secret anymore!