[andrew]

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")<b r />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 />
Thanks
Andrew

[alex]

What versions of windows, odbc and oracle are you running?

[Nazir]

The 80004005 error message indicates that your data cannot be accessed. This error can be paraphrased as "I could not access your data for some reason.".

There could be a number of reasons why this could occur, I would recommend having a look at the following website for more details:

http://support.microsoft.com/default...;en-us;Q306518