Email back password ----ASP

1

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!

2

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.

3

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’.

4

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