ODBC error while connecting to database

<i><b>Originally posted by : Mona</b></i><br />Hi,<br /><br />What does this error mean?<br /><br />I get this error message when I try to connect to database(oracle), on my PC (NT workstation).<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <br /><br />/programs/dblist.asp, line 9 <br /><br />I am using this program to connect to database.<br /><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 /><FORM ACTION="dblistrespond.ASP"METHOD="POST"><br /><SELECT NAME="ENAME"><br /><%<br />'NOW LETS GRAB ALL THE DATA<br />DO UNTIL RSTEMP.EOF %><br /><OPTION> <%=RSTEMP(0)%> </OPTION><br /><%<br />RSTEMP.MOVENEXT<br />LOOP<br /><br />RSTEMP.CLOSE<br />SET RSTEMP=NOTHING<br />CONNTEMP.CLOSE<br />SET CONNTEMP=NOTHING<br />%><br /><INPUT TYPE="SUBMIT" VALUE="Choose Employee Name"><br /></SELECT></FORM><br /></BODY></HTML><br /><br />Thanks<br /><br />

<i><b>Originally posted by : steve</b></i><br />http://www.activeserverpages.com/learn/dsn1.asp here is an article how to setup Data Source Names. If your using Oracle I'd make sure you have the latest mdac. Microsoft data access components. if unsure u can download the latest at http://www.microsoft.com/data/ get at least 2.1.2. <br /><br />steve<br /><br /><br />------------<br />Mona at 2/15/2000 9:10:39 AM<br /><br />Hi,<br /><br />What does this error mean?<br /><br />I get this error message when I try to connect to database(oracle), on my PC (NT workstation).<br /><br />Microsoft OLE DB Provider for ODBC Drivers error '80004005' <br /><br />[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified <br /><br />/programs/dblist.asp, line 9 <br /><br />I am using this program to connect to database.<br /><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 /><FORM ACTION="dblistrespond.ASP"METHOD="POST"><br /><SELECT NAME="ENAME"><br /><%<br />'NOW LETS GRAB ALL THE DATA<br />DO UNTIL RSTEMP.EOF %><br /><OPTION> <%=RSTEMP(0)%> </OPTION><br /><%<br />RSTEMP.MOVENEXT<br />LOOP<br /><br />RSTEMP.CLOSE<br />SET RSTEMP=NOTHING<br />CONNTEMP.CLOSE<br />SET CONNTEMP=NOTHING<br />%><br /><INPUT TYPE="SUBMIT" VALUE="Choose Employee Name"><br /></SELECT></FORM><br /></BODY></HTML><br /><br />Thanks<br /><br />