Meaningless Drivel is fun!
The moose likes JDBC and Relational Databases and the fly likes ODBC driver and 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 "ODBC driver and DSN" Watch "ODBC driver and DSN" New topic

ODBC driver and DSN

Amruta Agarwal

Joined: Apr 11, 2007
Posts: 11
O/S Windows XP Prof
ODBC driver is used for talking to a ODBC database or ODBC datasource.
For that we create a DSN, which could either be a system or a user dsn.

Now the question is when should a system dsn be created and when should a user dsn be created.
Also the drivers shown as choices are the installed with windows or does one have to obtain the driver himself?

Thanks and Regards,
Herman Schelti
Ranch Hand

Joined: Jul 17, 2006
Posts: 387
hi Amruta,

I've always used System DSN, it applies for all users of a PC.
(just look at the text just above the "OK", "Cancel" etc buttons)

I've also always used the default drivers that Microsoft offers.
If your database has only 1 concurrent user, and you only need old JDBC features this will probably do.

Jeff Ash

Joined: Apr 07, 2007
Posts: 11
A good rule of thumb on the System/User DSN issue is that if the application is running as a user other than the one you are logged in as (i.e. in the case of a Web server or other Windows service), then you must use a system DSN. Otherwise, a user DSN will work. However, like the other reply said, a System DSN will always work.

The main reason to use a user DSN is when you want to limit access to a particular DSN configuration to a particular user. This is when a user DSN should be used instead of a System DSN.

Jeff Ash<br /><a href="" target="_blank" rel="nofollow">Excellentia Software</a>
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63852


There aren't many rules that you need to worry about here on the Ranch, but one that we take very seriously regards the use of proper names. Please take a look at the JavaRanch Naming Policy and adjust your display name to match it.

In particular, your display name must be a first and a last name separated by a space character, and must not be obviously fictitious.

JavaRanch Sheriff

[Asking smart questions] [About Bear] [Books by Bear]
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63852

Originally posted by alwaysnewbie:
P.S. I have posted my question in this thread as the subject was appropriate, even though the question is off track from the above one. Sorry if I have misdirected this thread.

This is known as a thread hijack and is not allowed. Please post your question in your own newly created topic, after you change your display name as directed.
[ May 20, 2007: Message edited by: Bear Bibeault ]
I agree. Here's the link:
subject: ODBC driver and DSN
It's not a secret anymore!