
24/05/2003, 13:43
|
 | | | Fecha de Ingreso: agosto-2002 Ubicación: Guatire
Mensajes: 46
Antigüedad: 22 años, 8 meses Puntos: 0 | |
Error Data Base tengo el siguiente error, por favor que alguien me pueda ayudar agradezco:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/counter1.inc, line 8
----------------------------------------------------------
el codigo problema es este:
<%
dim connCounter, DSN, rsCounter, sqlCounter, sqlUpdate
Set connCounter = Server.CreateObject("ADODB.connection")
'connCounter = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("data/vortec.mdb")
'connCounter = "Provider=Microsoft.Jet.OLEDB.3.51; Data Source=" & Server.MapPath("db/vortec.mdb")
'connCounter = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("data/vortec.mdb")
connCounter.Open "DSN=basevortec"
sqlCounter = "SELECT counter FROM contador"
Set rsCounter = Server.CreateObject("ADODB.Recordset")
rsCounter.Open sqlCounter, connCounter, 3, 3
response.write rsCounter("counter") & ""
sqlUpdate = "UPDATE contador SET counter = counter +1 "
connCounter.Execute(sqlUpdate)
rsCounter.close
set rsCounter = nothing
connCounter.close
set connCounter = nothing
%> |