email back password ----ASP

[SBUH]

I had a asp email back code in attachment, it does not work but I did not get what is wrong with it!

I am using my own PC Win 2k professonal as server, in IIS I installed SMTP.

Or welcome any sugestion to have this function!

[Digitalosophy]

hmm well not to rearange your code but


<% Dim conn

MyPath=Server.MapPath("../db.mdb")

Set conn = Server.CreateObject("ADODB.Connection")

conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath

SQL = "SELECT password FROM customer WHERE email = '" & email & "'";

Set r = conn.Execute(SQL) %>


Where


r


Can be used to handle your records.



<% Reponse.Write r("email")%>


Hope that helped.

[SBUH]

Thanks for your reply and If I use conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath

and I got the error like this(I am using MS SQL 2000):
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 0x7d0 Thread 0x8a0 DBC 0x1c411ec Jet'.

[Digitalosophy]

What kind of database are you connecting to? Just connect whatever way you wer ebefore and impliment the code I provided