Can anyone explain the difference between the User DSN and a System DSN?
Actually can anyone explain in simple language what the DSN means?

I'm not sure of the differences between them, but DSN stands for Data
Source Name, basically it's an ODBC(32) Alias that uses Microsoft
drivers to access a database table. For example, if your program can't
open MS Access 2000 tables because they're not supported by the BDE, you
can set up a DSN in the control panel which will appear in the dropdown
list of the property inspector.

This will allow your database components to open database files not
necessarily supported by the BDE. It's a bit slower than normal, because
the M$ drivers are used instead of the native ones, but it's quite
powerful. They're used a lot in ADO programming.

HTH :)

John.