How to use ADO?

<i><b>Originally posted by : Mona</b></i><br /><br />Hi,<br /><br />Can somebody help me with ADO..?<br />I have tried connecting to database using ADO and I am getting this error message.<br /><br />"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified "<br /><br />The code I am writing is<br /><%<br />MYDSN="DSN=LOCAL1;UID=SCOTT;PWD=TIGER"<br />MYSQL="SELECT ENAME FROM EMP"<br />' DISPLAY A DATABASE FIELD AS A LISTBOX<br />SET CONNTEMP=SERVER.CREATEOBJECT("ADODB.CONNECTION")<br />CONNTEMP.OPEN MYDSN<br />SET RSTEMP=CONNTEMP.EXECUTE(MYSQL)<br />IF RSTEMP.EOF THEN<br />RESPONSE.WRITE "NO DATA FOR<BR>"<br />RESPONSE.WRITE MYSQL<br />CONNTEMP.CLOSE<br />SET CONNTEMP=NOTHING<br />RESPONSE.END<br />END IF<br />%><br /><br />What all do we need to have installed on the machine in order to connect to database using ADO.<br /><br />Thanks

<i><b>Originally posted by : steve schofield (sschofield@aspfree.com)</b></i><br />here is an article on setting up this step by step and w/pic's. <br /><br />http://www.activeserverpages.com/learn/dsn1.asp<br /><br />steve<br /><br /><br />------------<br />Mona at 2/15/2000 9:48:48 AM<br /><br /><br />Hi,<br /><br />Can somebody help me with ADO..?<br />I have tried connecting to database using ADO and I am getting this error message.<br /><br />"[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified "<br /><br />The code I am writing is<br /><%<br />MYDSN="DSN=LOCAL1;UID=SCOTT;PWD=TIGER"<br />MYSQL="SELECT ENAME FROM EMP"<br />' DISPLAY A DATABASE FIELD AS A LISTBOX<br />SET CONNTEMP=SERVER.CREATEOBJECT("ADODB.CONNECTION")<br />CONNTEMP.OPEN MYDSN<br />SET RSTEMP=CONNTEMP.EXECUTE(MYSQL)<br />IF RSTEMP.EOF THEN<br />RESPONSE.WRITE "NO DATA FOR<BR>"<br />RESPONSE.WRITE MYSQL<br />CONNTEMP.CLOSE<br />SET CONNTEMP=NOTHING<br />RESPONSE.END<br />END IF<br />%><br /><br />What all do we need to have installed on the machine in order to connect to database using ADO.<br /><br />Thanks