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?
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="http://www.excellentiasoftware.com" target="_blank" rel="nofollow">Excellentia Software</a>
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 ]