Difficulty: Easy
Correct Answer: File data source
Explanation:
Introduction / Context:
ODBC data sources (DSNs) can be stored in different ways. Understanding User, System, and File data sources helps administrators share connection settings and simplify deployments across teams and machines.
Given Data / Assumptions:
Concept / Approach:
A File Data Source (file DSN) stores connection information in a text file (typically with a .dsn extension). Because it is file-based, it can be distributed and reused across systems. By contrast, User and System DSNs are stored in the Windows registry and are machine-bound.
Step-by-Step Solution:
Verification / Alternative check:
Windows ODBC Data Source Administrator provides tabs for User DSN, System DSN, and File DSN, illustrating their storage locations.
Why Other Options Are Wrong:
Common Pitfalls:
Assuming DSN-less connection strings in applications replace DSNs entirely; they can coexist depending on deployment strategy.
Final Answer:
File data source
Discussion & Comments