请教各位：ODBC的用户DSN和系统DSN有什么区别和联系？

[salragh]

谁能帮我解释一下？

[40Star]

用户值当前的如NT，2000不是有用户的区别吗
系统的就是无论一什么身份登陆DSN都会存在

[vcpb]

一个是针对不同用户而不同
一个是所有用户都可以使用

An ODBC data source name (DSN) can be one of the following types:

User - A data source local to a computer and accessible only by the current user that created the data source.
System - A data source local to a computer but not dedicated to a specific user, so any user with appropriate privileges can access a system DSN. A System data source is visible to all users on a computer, including Windows NT services.
File - A data source stored in a file that can be shared among all users who have the same ODBC drivers installed. These data sources need not be dedicated to a specific user or local to a computer.

[killerdanny]

在注册表的位置不同.

[NetCobra]

用户DSN：存储在注册表HK_CURRENT_USER\Software\ODBC\ODBC.INI中，只对当前用户可用，当你用另一个用户的身份登陆时该DSN即不可见。
系统DSN：存储在注册表HK_LOCAL_MACHINE\Software\ODBC\ODBC.INI中，对所有用户可用。