error de coneccion nuevamente

[bisteck]

hola , disculpen que los moleste pero tengo este error

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][Controlador ODBC Microsoft Access]Error general No se puede abrir la clave 'Temporary (volatile) Jet DSN for process 0x3b8 Thread 0x6b0 DBC 0x28a5014 Jet' del Registro.
/victor/prueba/ecommerce/revisarusario.asp, line 14

y creo , por lo que e leido , es que la ruta de mi base de datos no existe

pero si existe y esta bien.

otra cosa el programa ayer me funcionanba de maravilla y ahora que lo veo me sale este error y no se como solucionarlo, e quitado mi base de dato en el ODBC para luego seleccionarlo de nuevo pero me sigue el mismo error

a qui esta el codigo


<%
'Para los redireccionamientos
Response.Buffer=True

Dim oConn, rs, SQL, nombre, password

'Recogemos el formulario
nombre = Request.Form("usuario")
password = Request.Form("pass")


'Validamos su identidad
set oConn=Server.CreateObject("ADODB.Connection")
oConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Inetpub\wwwroot\victor\base\melon.mdb;" <--- la linea 14

SQL="SELECT * FROM " & _
"Cliente WHERE (codigo_cli='"&nombre&"' AND password='"&password&"');"

'Ejecutamos consulta
set rs=oConn.Execute(SQL)

if rs.EOF then

'No existe ese usuario con esa contraseña
'Así que le negamos el acceso
session("autorizacion")=-1
Response.Redirect("../templates/noexiste.htm")
else


session("autorizacion")=1
session("login")=nombre
response.redirect "vigente2.asp"
end if


rs.close
Set rs = Nothing
oConn.close
Set oConn = Nothing
%>


y realmente no se que hacer

please un consejo o ayuda
gracias

[orharo2003]

Te lo dejo documentado, a no ser de que otro experto del foro demuestre lo contrario al error.

Here are possible causes for this error, which happens when you try to open a Jet DSN connection (or any connection to a MS Access database) from an ASP (or other) script:

the webserver environment needs "write" permission to the directory where the Access database resides. So, set permissions first. Go to Windows Explorer, Tools, Folder Options, View and turn off the very last entry in the list ("Use simple file sharing") if you haven't already done so.
Now, you'll have a "Security" tab when you right-click on a folder. Make sure you give write permission to the folder with the MS Access database to the "IUSR_***" account (with *** being your computer's name). This account is used by IIS, per default, to evaluate permissions for the default access to your local PWS website and scripts.
You can create your own User account by the way and set it as default for anonymous access of PWS. To do this, go to Control Panel, Administrative tools, Internet Information Server, expand "local computer," right-click on Websites (if you don't have this, add IIS from your Windows XP Pro CD. If you have Windows XP Home... tough luck you can't run a webserver, you have to upgrade.) Select "Properties," Directory Security, "Edit." Here you see the default account and logon. You can create another user account (under "Control Panel," "User Accounts") with another password and enter this here. BUT you don't have to do all this to take care of the error above; IUSR_<machine name> is fine for now. I digress...
Give the same user IUSR_<machine name> (or whatever is the default account) access to the TEMP directory of Windows. MS Access might need to write some stuff there.
Give the same account write permission in MS Access itself. These permissions can be reset by MS Access if you compact and repair the database so keep in mind to refresh this permission as necessary.
If you still get the error "[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process", check that the database is really in the directory referenced by the DSN or the connection string in your ASP file! Also, check for misspellings in the file name. This was the reason for the error when I ran into it earlier this week.

Otra más:

http://www.aspemporium.com/aspEmpori...id=1981&fid=11

Suerte!