Unable to open registry-ODBC Driver error

J

Jim T

I found a couple of VBScripts on the net to provide a Logon/Password prompt
to secure some pages on the Web I'm developing for my home town. I modified
the two scripts, one to display the prompt and the second to do a query and
check against my Access DB that contains the user ID's and passwords. The
user ID/password script is named check.2.asp and contains the following code
(the last line is the fail point).

I'm new at VBScript but have a fair amount of VBA coding. Is there a good
debugger, especially with a line step and variable value functions? In the
mean time any help with the problem below?

dbname="/localhost/fpdb/town4web.mdb"
myname=request.form("logon_name")
mypassword=request.form("PIN")
set conntemp=server.createobject("adodb.connection")
cnpath="DBQ=" & dbname
conntemp.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x87c Thread 0xbc DBC
0x105900c Jet'.
/check.2.asp, line 24
 
J

Jim T

Sorry I didn't include this in my original question: The DB in question was
imported into the web and connection set using the wizard. I have tested the
connection by creating a test ASP page and inserted DB results. The results
returned was OK.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top