DSN and DSN-Less Connection

15 pts.
Tags:
Data Source Name
DSN
ODBC
What is difference between DSN and DSN less Connection? Which is better to use and Why?

Answer Wiki

Thanks. We'll let you know when a new response is added.

A DSN connection makes use of a system or file DSN (hence the name). These are convenient because if you need to change the settings you don’t have to do find the info in the config file looking for the connection string. You have a nice little wizard to walk you through making the changes to the DSN. The downside to the DSN is that you have to make sure that the DSN is setup correctly on each machine that you are installing the software on.

Using just a connection string is nice because it’s easier to find the connection string as it’s in the same place as all the other settings. With having the connection string within the config file you also have the ability to encrypt the connection string which you don’t have when using the DSN.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ritchie1
    Although you can not encrypt a DSN - the password is not shown - all that is visible is the Servername /IP Address and the sql user / windows authentication so it is not open for all to see, but DSN-less connection contains all the information including password - although if not encrypted this is not directly visible. DSN's are commonly setup using the wizard but they can be installed programmatically. The easiest way is to set one up on a PC using the wizard, then open regedit and search for the DSN name. This can then be exported as a .reg file which can be installed programmatically / in start-up files etc.
    210 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following