This thread is for discussions of Creating a Members Area in ASP

I have been getting the following error:

The following errors occured:
- An error occured. -2147217900 : Syntax error in INSERT INTO statement.

Hi,

I had the same problem and found out that it may a problem with reserved words, although I cannot find 'username' or 'password' in the reserved word list for 'MS Access' in my case. The solution is to place [ ] around the field names in the SQL statement.

Thanks for pointing that out... as I work almost entirely with SQL Server, I forget about things like that... ;-) I have added the []'s around username and password

Anyone knows what this file is or does (msado21.tlb). It's part of NT4 IIS4. All I know that it has something to do with Global.asa files and SQL databases.
C:\Program Files\Common Files\System\ADO\msado21.tlb

Thanks,

Mo

If you are writing a program/dll in VB/C++ etc you can reference that type library which makes it easy to use Microsoft ADO etc....

In Active Server Pages, you create an ADO object by using Server.CreateObject("ADODB.Connection") or whatever..

Hello. I tried your code for the member's only site, and it works nice, I'm having some trouble though with one aspect of it. The code says if error 222 happens, then the user would be prompted with the error message that the username in already in use, I tested it, registering one username with a password, then registering that same username again. It should've not let me register that name, but it let it go, registering the user, basically, its not checking to see if a user already existst with that name.

I tried this code and it does not work for me. I am using Brinkster.com web hosting, with ASP/ASP.net(ASP 3.0).

Here are the problems I am experiencing:

1. Register.asp allows me to register duplicate usernames, with NO error messages.
2. Even after I register, and login.. i am not taken to the members page. No matter what I do, it says, invalid username/password!!

Please test it out!
Here is the address: http://www25.brinkster.com/urbanaffilntwrk/register.asp

Please help!

djfinesse_215@yahoo.com

Here's my sql statment to my Access Database to create my table for members:
CREATE TABLE members
    (id AUTOINCREMENT PRIMARY KEY,
     [username] char(20),
     [password] char(20))

This creates the table successfully.

Step one is fine!

After i register, I get taken to the login page.. then it never lets me log in, sayin that invalid user/password!!

I just ran a query on the db and all the info was there. I am puttin in the right info, but it neveer takes me to the member page!!!!

Please help!!!

I really need this member section!!!

Okedoke, I made a table in MS Access, uploaded it to my db directory. I am almost positive everything is right in the inc-connection.asp file. When I go to registration page, I get a Error 500 Internal Server error. It also takes a while to "open the page". Can you fill me in here anyone? I am using Brinkster.com

On what line does the error occur? (you may need to enable server-side debugging from the IIS console)

Are cookies enabled? You must have cookies enabled in order to be able to login.

Yes, cookies are enabled on every browser that has tried the script. It is just not working. I just tried it another machine and it still does not work.

Finesse

James Crowley said:
Quote:

Are cookies enabled? You must have cookies enabled in order to be able to login.

It doesn't work because they don't support session variables for general membership.

Ok.

Finesse