Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

difference in User DSN,File DSN & System DSN

 
yashendra chandrakar
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
what exectly is the difference in User DSN,File DSN & System DSN
thanx in advance
Yashendra
 
Uma P.
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
User DSN : only the current user on the machine can use the DSN.
System DSN : all users and in particular Web Applications on the machine can use this (use in JSP page)
File DSN: like a persistent DSN on the machine across users
for more info check ODBC Administrator help.
 
yashendra chandrakar
Greenhorn
Posts: 22
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanx Uma for your valuable response.
yashendra
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic