Multiple choice asp ado

There are two methods of connecting to an Access database. Which are they?

  1. DNS, DNS-less

  2. DSN, DSN-less

  3. ODBC, ADO

  4. OLEDB, ADO
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The two methods for connecting to an Access database via ADO are DSN (Data Source Name) and DSN-less connections. DSN connections use a system or file DSN configured in the ODBC Data Source Administrator. DSN-less connections specify all connection parameters directly in the connection string. DSN-less connections are often preferred for portability since they don't require pre-configuration on the server.

AI explanation

Access (and other ODBC-based databases) can be reached either through a DSN (Data Source Name), a named, pre-configured connection registered on the system, or DSN-less, where the connection details (driver, path) are specified directly in the connection string at runtime. These are the two standard ODBC connection approaches; ADO/OLEDB and "DNS" (a naming service, unrelated to databases) are not the two methods being asked about.

Keep practicing — related questions