Database connection error...

<i><b>Originally posted by : Sandhu (mk_sandhu@hotmail.com)</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 />And I also get the following error message while connecting to access database.<br /><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/master.asp, line 37 <br /><br />Thanks,<br />Sandhu<br /><br />

<i><b>Originally posted by : </b></i><br /><br />You need to post the which you are using to connect to your DB.<br /><br /><br />------------<br />Sandhu at 2/13/2000 7:31:25 PM<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 />And I also get the following error message while connecting to access database.<br /><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/master.asp, line 37 <br /><br />Thanks,<br />Sandhu<br /><br />

<i><b>Originally posted by : Sandhu (mk_sandhu@hotmail.com)</b></i><br />Hi<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 /><FROM 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 /><br /><br />------------<br /> at 2/14/2000 7:01:04 AM<br /><br /><br />You need to post the which you are using to connect to your DB.<br /><br /><br />------------<br />Sandhu at 2/13/2000 7:31:25 PM<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 />And I also get the following error message while connecting to access database.<br /><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/master.asp, line 37 <br /><br />Thanks,<br />Sandhu<br /><br />

<i><b>Originally posted by : clive (garrec01@hotmail.com)</b></i><br /><br />It appears you have not set a DSN.<br /><br />------------<br />Sandhu at 2/14/2000 7:19:55 AM<br /><br />Hi<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 /><FROM 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 /><br /><br />------------<br /> at 2/14/2000 7:01:04 AM<br /><br /><br />You need to post the which you are using to connect to your DB.<br /><br /><br />------------<br />Sandhu at 2/13/2000 7:31:25 PM<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 />And I also get the following error message while connecting to access database.<br /><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/master.asp, line 37 <br /><br />Thanks,<br />Sandhu<br /><br />