ODBC without DSN

Is a connection string an ADO thing, which has nothing to do with
ODBC?

When using ODBC, is there a practical alternative to setting up a DSN
on each user's machine?