to setup the OBDC to run DSN, do this !!!
- Click start -> programs -> administrative tools -> data sources (ODBC)
- Click on the system DSN tab then the add button
- Select Microsoft Access driver and click finish
- Enter the name of the DSN as "cds"
- Click on the select button and browse to your Access database
- Click OK and you're done
the connection to the database is like this !!!
<%
dim conn
dim rs
set conn = Server.CreateObject("ADODB.Connection")
set rs = Server.CreateObject("ADODB.Recordset")
conn.Open "DSN=DBNAME" (whitout .mdb JUST the name)
rs.ActiveConnection = conn
rs.Open "SELECT * FROM cds ORDER BY title ASC"
while not rs.EOF
%>
and so on !!!!
remember to CLOSE the connection again !!!!