Adding new user to database from Web registraton

[xfile]

Hi:

I recently downloaded some ASP pages with Access database verifying and
adding Web site users.

I managed to make most of them work except for the last step of adding new
registrant to the database and return for an "anewmember.asp"

This is basically how those codes works:

(1) Login.asp: Login screen for registered user to type in their ID and
password. Data will be sent to "Member.mdb" for verification. If passed,
it will redirect to another page. If not, it will return to the
registration form again. This part has no problem. There are sample data
in the database, and if I typed the correct one, I will be directed to the
protected page. If not, I will be redirected to another registration form.

***I guess this meant that the database - Member.mdb can be read if I can
check on its data***

(2) Signup: This is the problem. After filled out registration form and
pressed "Submit," it will be redirected to a "Confirm.asp" where user can
confirm all information and if right, click "Confirm" to process the data
and upon completion, an "anewmember.asp" will be displayed.

Here is the error message after pressed "Confirm button"
---------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]¤@ 'Temporary (volatile) Jet DSN
for process 0xca4 Thread 0xa10 DBC 0x16745f4 Jet'¡C

/0501-Product/Membership/addnewmember.asp, line25

----------------------------------------------------------------

Here is codes from line 24-26

Line 24: set my_conn= Server.CreateObject("ADODB.Connection")
Line 25: my_Conn.Open ConnString
Line 26: set rscheck = my_conn.Execute ("Select email from member where
email='" & email & "'")

 

[Norman Yuan]

What is the value in the variable ConnString? Is the value the same as you
used in Login.asp?

 

[xfile]

Hi:

Sorry for I am not familiar with database at all so I am not sure if I
understand your question correctly.

Are you saying something like this --
ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("member.mdb")

Do I have to change something to make it the same as in the Login.asp? If
so, where shall I check in the Login.asp?

Thanks in advance.

What is the value in the variable ConnString? Is the value the same as you
used in Login.asp?

Hi:

I recently downloaded some ASP pages with Access database verifying and
adding Web site users.

I managed to make most of them work except for the last step of adding new
registrant to the database and return for an "anewmember.asp"

This is basically how those codes works:

(1) Login.asp: Login screen for registered user to type in their ID and
password. Data will be sent to "Member.mdb" for verification. If passed,
it will redirect to another page. If not, it will return to the
registration form again. This part has no problem. There are sample data
in the database, and if I typed the correct one, I will be directed to the
protected page. If not, I will be redirected to another registration form.

***I guess this meant that the database - Member.mdb can be read if I can
check on its data***

(2) Signup: This is the problem. After filled out registration form and
pressed "Submit," it will be redirected to a "Confirm.asp" where user can
confirm all information and if right, click "Confirm" to process the data
and upon completion, an "anewmember.asp" will be displayed.

Here is the error message after pressed "Confirm button"
---------------------------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]¤@ 'Temporary (volatile) Jet DSN
for process 0xca4 Thread 0xa10 DBC 0x16745f4 Jet'¡C

/0501-Product/Membership/addnewmember.asp, line25

----------------------------------------------------------------

Here is codes from line 24-26

Line 24: set my_conn= Server.CreateObject("ADODB.Connection")
Line 25: my_Conn.Open ConnString
Line 26: set rscheck = my_conn.Execute ("Select email from member where
email='" & email & "'")