Buenos dias! Me surgio un inconveniente con una web interna para mi trabajo. Estoy tratando de hacer que en una pagina html realice una busqueda de un dato que se encuentra en una base de datos de access. Esa informacion es cargada por otras paginas de la misma web.
Adjunto mi codigo para ver cual puede ser el error.
Actualmente cuando quiero realizar la busqueda me aparece el siguiente error:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not find file '(unknown)'.
/PoolGamma/search.asp, line 34
Adjunto codigo del html y asp
search.htm
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft FrontPage 5.0">
<TITLE>Project Status Seach</TITLE>
</HEAD>
<body bgcolor="#FFFFFF" bgproperties="fixed" background="ibmbackgroundsuave.jpg">
<p style="margin-top: 0; margin-bottom: 0">
<img SRC="ServiceManagement.bmp" width="600" height="95">
<table width="84%" align="left">
<td width="50%" align="right">
<table align="left">
<td align="center">
<p style="margin-top: 0; margin-bottom: 0">
<a href="../../Default.htm"><font color="#000080">Start</font></a>
<font color="#000080"> | </font>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p style="margin-top: 0; margin-bottom: 0">
<a href="../../Default.htm"><font color="#000080"><br>
<br>
<p style='margin:0cm;margin-bottom:.0001pt;line-height:150%'><marquee behavior="Alternate" scrolldelay="50" scrollamount="4"
style="font-size: 20pt; color: #00009C; font-weight: bold">Project Status Seach</marquee></p>
</font></a> </p>
<hr>
<FORM name="sea" action="../PoolGamma/search.asp" method=post>
<P><font color="#000080" size="4"><b><u>Section search of data</u></b></font> </P> <P><font color="#000080"><b></b></font> <br>
<br>
<INPUT NAME="texto" size="25" tabindex="0"><b>(Enter name of pool member or Project Name to start searching project status information )<br>
<P>
<INPUT type=submit value=Search tabindex="2"> & nbsp;
<INPUT type=reset value=Erase tabindex="3"><br>
<br>
<font color="#000080"><b><u>NOTE :</u></b></font> If you leave blank "Search of dat" field, and you press "Search" you will receive the whole information of the projects.</P>
<table width="84%" align="left">
<tr>
<td width="50%" align="right">
<table align="left">
<tr>
<td align="center">
</FORM>
<table width="84%" align="left">
<td width="50%" align="right">
<table align="left">
<td align="center">
<p style="margin-top: 0; margin-bottom: 0">
<a href="../../Default.htm"><font color="#000080">Start</font></a>
</td>
</tr>
</table>
</td>
</tr>
<p>
</BODY>
</HTML>
search.asp
<HTML>
<TITLE> Search Project Status information </TITLE>
<body bgcolor="#FFFFFF" bgproperties="fixed" background="ibmbackgroundsuave.jpg">
<p style="margin-top: 0; margin-bottom: 0">
<img SRC="ServiceManagement.bmp" width="570" height="95"> </p>
</p>
<table width="84%" align=left>
<td width="50%" align=right>
<table align="left">
<td align="center">
<p style="margin-top: 0; margin-bottom: 0">
<a href="../../Default.htm"><font color="#000080">Start</font></a>
<font color="#000080"> | </font>
<a target="_top" href="search.htm"><font color="#000080">Project Status Seach</font></a>
<font color="#000080"> | </font>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p style="margin-top: 0; margin-bottom: 0">
</p>
<br>
</p>
<hr>
<%
acc = request.querystring ("texto")
Sql= "SELECT * FROM Dispatching WHERE Account LIKE '%" & acc & "%' ORDER BY PMAssigned"
dbfile=Server.MapPath("../ticketsgenerales.mdb")
Set OBJdbConnection=Server.CreateObject("ADODB.Connect ion")
OBJdbConnection.Open "driver={Microsoft Access Driver (*.mdb)};dbq="&dbfile
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, OBJdbConnection, 3, 3 %>
<CENTER>
<TABLE BORDER=1>
<TR>
<tr bgcolor= "#8F8FBD">
<TH> Clave </TH>
<TH> Pool </TH>
<TH> Ente Date </TH>
<TH> Project Name </TH>
<TH> Project Brief Description </TH>
<TH> Technical Speciality </TH>
<TH> Account </TH>
<TH> PM Assigned </TH>
<TH> Project Complexity </TH>
<TH> Amount Of FTEs Required </TH>
<TH> Project Phase </TH>
<TH> Project Priority </TH>
<TH> Status </TH>
<TH> Project Start Date </TH>
<TH> Project Planned Finish Date </TH>
<TH> Actual Project Finish Date </TH>
<% DO UNTIL rs.Eof %>
<TR>
<tr bgcolor= "#7093DB">
<TD> <CENTER> <%= rs("Clave") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("Pool") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("EnterDate") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ProjectName") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ProjectBriefDescription") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("TechnicalSpeciality") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("Account") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("PMAssigned") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ProjectComplexity") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("AmountOfFTEsRequired") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ProjectPhase") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ProjectPriority") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("Status") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ProjectStartDate") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ProjectPlannedFinishDate") %> </CENTER> </TD>
<TD> <CENTER> <%= rs("ActualProjectFinishDate") %> </CENTER> </TD>
<% rs.MoveNext
LOOP
set rs = Nothing
OBJdbConnection.Close
set OBJdbConnection = Nothing%>
</TABLE>
<img SRC="telefono_sonrisa.gif" width="100" height="100">
<table width="84%" align="left">
<tr>
<td width="50%" align="right">
<table align="left">
<tr>
<td align="center">
</FORM>
<table width="84%" align="left">
<td width="50%" align="right">
<table align="left">
<td align="center">
<p style="margin-top: 0; margin-bottom: 0">
<a href="../../Default.htm"><font color="#000080">Start</font></a>
<font color="#000080"> | </font>
<a target="_top" href="search.htm"><font color="#000080">Project Status Seach</font></a>
<font color="#000080"> | </font>
</p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<p>
</BODY>
</HTML>
Muchas gracias!!!!