Adding new user to database from Web registraton

[xfile]

**** I double posted to Access forum since I don't know which one is the
right one, sorry!!!!****

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 "Submint," it will be redirected to a "Confirm.asp" where user can
confirm all information and if right, click "Confimr" 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 & "'")

 

[Net55]

Make sure the the database and folder are read/write

Net55
(e-mail address removed)
http://www.frontpagewiz.com

 

[+FarmerPickles]

i dont see where you have the name and path of the DB in the script, unless
i am missing something.
Jeff


Make sure the the database and folder are read/write

Net55
(e-mail address removed)
http://www.frontpagewiz.com

 

[xfile]

Hi

Thanks for your tips. Folder is checked with Windows Explorer and it is
read and write. Since verification of existing user ID and password can be
checked against the database, I assume it can be, at least, read.

About the path of the database, you're right and it is not on the line
24-26, it is on line 24 as follows:
----------------------------------
ConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" &
Server.MapPath("member.mdb")
----------------------------------------
I did try to change ("member.mdb") to ("membership\member.mdb") where
"membership" is the folder store member.mdb

Thanks.....

i dont see where you have the name and path of the DB in the script, unless
i am missing something.
Jeff


Make sure the the database and folder are read/write

Net55
(e-mail address removed)
http://www.frontpagewiz.com

-----Original Message-----
**** I double posted to Access forum since I don't know which one is the
right one, sorry!!!!****

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 "Submint," it will be redirected to a "Confirm.asp" where user can
confirm all information and if right, click "Confimr" 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 & "'")

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

Many thanks in advance!!!







.