Question:
WhatisDSN?
Answer:
Source: CoolInterview.com
Data source name.contains information about how to connect to the specified provider. User DSN,System DSN,File DSN Source: CoolInterview.com
Answered by: Ashwin | Date: 9/11/2007 10:10:33 AM
| Contact Ashwin
Data Source Name (DSN) is used to store the connection string in a file format. It holds the information about the Server Name; Database Name, Provider, User Name, Password etc.
There are three types of DSN:
System DSNs System DSNs work for anyone using that system. For example, no matter who logs onto the machine, system DSNs can be seen by all users, and they are stored in the Local Machine section of the Registry.
User DSNs User DSNs work only for a specific user on a machine. Therefore, if someone other than the person who created the user DSN logs onto that machine, then the User DSN will not show up. This DSN is stored in the Current User section of the Registry.
File DSNs File DSNs are not stored in the Registry but rather in a file. That means you can store these DSNs to disk or network and use them on any machine or any user that has access to it. Source: CoolInterview.com
Answered by: Abhishek Saxena | Date: 4/28/2009
| Contact Abhishek Saxena
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|