http://www.learnasp.com/freebook/learn/dbopen.aspx
shows correct Access connection string.

www.learnasp.com/freebook/learn/datareader.aspx
is small datareader  example.

Just search for SQLClient replace with OLEDB.

DSNs actually imply an ODBC connection which is slower than SQLClient or OLEDB. So avoid DSNs. A lot of Classic asp  programmers using DSNs were getting worse pefrformance via ODBC instead of OLEDB and never knew it. ASP.net wants to end people accidentally using ODBC without knowing it.