ODBC data source types In ODBC terminology, what do you call a data source that is configured on and local to a single computer (available to the system and its users on that machine)?

Introduction / Context:An ODBC Data Source Name (DSN) encapsulates connection information such as driver, server, database, and authentication method. DSNs come in several types that determine scope and storage, which affects who can use them and where they live.

Given Data / Assumptions:

• We want a DSN that is local to one computer.
• It should be available system-wide on that machine (services and all users can use it).
• Alternatives include per-user DSNs and file-based DSNs.

Concept / Approach:

A system data source (often called a System DSN) is stored in the machine-wide configuration so any user or service on that computer can use it. A user data source is limited to a single user profile. A file data source stores DSN settings in a portable .dsn file, which can be copied and used across machines if paths and drivers match.

Step-by-Step Solution:

Verification / Alternative check:

ODBC administrator tools on Windows categorize DSNs into User, System, and File; System DSN is the machine-level configuration.

Why Other Options Are Wrong:

• B: File DSN is portable via a file, not strictly “local only.”
• C: User DSN is local to a user profile, not system-wide.
• D/E: Not standard ODBC DSN categories.

Common Pitfalls:

• Creating a User DSN for a service account that runs under a different identity—use a System DSN for services.
• Copying File DSNs without ensuring identical driver versions on the new host.

Final Answer:

System data source.