Error in login form, please help.

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Other Development Tools

Error in login form, please help.

Author

Topic

Eagle_f90
Constraint Violating Yak Guru

424 Posts

Posted - 2004-06-12 : 21:30:28

I have a login page that uses both ASP and MS SQL 2k to let member's login to there own privet page. Most of the time it works fine but very now and then they get this error:
error '80020009'

/cgi-bin/password/protectnocookie.asp, line 52

The code at line 52 is:

response.redirect trim(objrs("address"))

The UID, Password, and Address they are redirected to is all stored in the DB.

Can anyone help me figure out why the users sometimes get that error?

--
For those with wings, fly to your dreams

Dearms are what are found at the end of reality, and your reality if what is found at the end of your dreams.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-06-12 : 21:52:00

What is the error description ?

Also, that's a REALLY bad way to do things. You are redirecting while your recordset and DB connection are still open. If you get lots of people doing that you will start to kill your server.

It should be more like :

dim strURL
strURL = trim(objrs("address")

objrs.close
set objrs = nothing

objConn.close
set objConn = nothing

response.redirect strUrl

Damian

Eagle_f90
Constraint Violating Yak Guru

424 Posts

Posted - 2004-06-24 : 21:06:55

Thank you for the suggestion on close the DB I will add the kill code before the redirect.

The users have friendlly http errors turned off and they say all the get is a white page with the error:

error '80020009'

/cgi-bin/password/protectnocookie.asp, line 52

--
For those with wings, fly to your dreams

Dearms are what are found at the end of reality, and your reality if what is found at the end of your dreams.

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-06-24 : 21:09:57

I think that means that your recordset is empty / null or that field is empty / null.

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources