Board index » delphi » user DSN or System DSN

user DSN or System DSN

Hi

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

Thanks
Pete

 

Re:user DSN or System DSN


Hi Pete,

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.

Quote
pete wrote:

> Hi

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

> Thanks
> Pete

Re:user DSN or System DSN


In article <[email protected]>, "pete"

Quote
<[email protected]> writes:
>Can anyone explain the difference between the User DSN and a System DSN?
>Actually can anyone explain in simple language what the DSN means?

If you open Start Menu | Settings | Control Panel > ODBC Data Sources there is
a description of what they do on the User DSN and System DSN tab sheets of the
ODBC Data Source Administrator. The differences are apparent from this
description.

Alan Lloyd
[email protected]

Other Threads