Asp Login Error Problems
I am trying to create an asp login wiht registration using asp and a ms access database.
However when i uploaded the asp pages onto the server it through up two problems. Code:
ADVERTISEMENT
Login Process Error
I have created 2 tables on my db. one is for customers and one for corporate. this is to distinguish the records so that we wont mix up our clients. i have created a login page for both customer and corporate. however, i think there is something wrong with the login process code which process the login for users to our page. there is an error message:Error Type:
Provider (0x80020005)
Type mismatch.
(see highlight in red) for attached code.i am not sure if its correct but here is the code as attached
<%
Response.Buffer = True
strUserName = Request.Form("User_Name")
strPassword = Request.Form("User_Password")
Dim rs
Dim sqlStr
Dim record_found
record_found = 0
Dim vPath, pPath, ConString
vPath = "xxxxx.mdb" 'use this one if database is in root of cart folder
pPath = Server.MapPath( vPath )
ConString = "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & pPath & ";" & "JET OLEDB:"
Dim Conn, rsCatalog
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open ConString
sqlStr1 = "SELECT * from Customer WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
sqlStr2 = "SELECT * from Corporate WHERE User_Name = '" & strUserName & "' AND User_Password = '" & strPassword & "'"
set rs = Server.CreateObject ("ADODB.Recordset")
adOpenStatic = 3
rs.CursorType = adOpenStatic
rs.Open sqlStr1, sqlStr2, conn
If (rs.RecordCount <= 0) Then
Response.Redirect("login.asp?from=no_record")
Else
record_found = 1
Response.Cookies("User_Name") = rs("User_Name")
Response.Cookies("User_Password") = rs("User_Password")
Response.Cookies("Login") = 1
Response.Cookies("View_Cart") = 0
End If
rs.Close
Set rs = Nothing
if record_found = 1 then
if Request.Form("hiddenVal") = "view_cart" then
Response.Redirect("view_cart.asp")
else
Response.Redirect("default.asp")
end if
end if
%>
Login Fails - Error
I am getting this error. Got it for the first time, so am really not sure why
"[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database requested in login '/dbmckenna'. Login fails.
/Sitter_Registration.asp, line 12 "
Sql Error 18452 Login Failed Reason: Not Associated With A Trusted SQL Connection
Not sure if this is the right place but I need to get this website going and am having problems with the ODBC driver connecting to the SQL server When setting up the driver I am getting a sql error 18452 login failed reason: not associated with a trusted SQL connection I am at a loss as I installed this on another machine and it worked.
View Replies View RelatedXMLHTTP Through Login But After Requesting Next Page - Kicks Back To Login
I am building a website to pull data from a remote https site using xmlhttp. The data from the https site is behind a login screen. I can successfully get through the login screen with:
set objXMLHTTP = Server.CreateObject("Msxml2.ServerXMLHTTP")
objXMLHTTP.Open "POST", "https://website.com/validate-login2.asp", false
objXMLHTTP.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
objXMLHTTP.Send "Username=uname&password=pwd&company=O"
That works great - but then, when I try to go to the next page (where the data is that I want to pull) - I use the same process and I get kicked back out to the login screen? Could there be some cookies, referer, strings being passed normally that I am not including in my second request - How do i find out for sure?
I have used the software IETrace and it looks like some cookies being passed, but how do I know for sure if (and what exactly) it is using?
Error "Cannot Open Database Requested In Login..."
The SQLServer and Web server are different computers. The error I got when logging on as ONLINE/ONLINE is "Cannot open database requested in login '<mydbname>'. Login fails.
/<mysitename>/validate.asp, line 12
Line 12 is: objConnection.Open Session("ConnectionParameter")
In global.asa, the setting is:
If Session("DataBaseBrand") = "SQLSERVER" Then
Session("ConnectionParameter") = "DSN=Alecto;UId=ONLINE;Pwd=ONLINE"
The names of UserID/Password fields on the form are dfsUserID/dfsPasswd
Below is validate.asp: Code:
Login To Page Requires Login
I want to login to a page using MSXML2.ServerXMLHTTP.4.0 or an object like this, I must send the form variables needed to login when I try to login to the page. But the problem is, that the page looks like a exe file (not a asp file or php file or what ever). The name of the page I try to login is something like "/pw?/session/login", nothing more, without extension. I have tried the code with a normal asp file with session registration and login process and it worked, but not with this file.
View Replies View RelatedI Have A Error Called Microsoft VBScript Runtime Error- Error '800a000d'
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code:
Error: HTTP 500.100 - Internal Server Error - ASP Error
# Error Type:
Server object, ASP 0177 (0x800401F3)
Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
/CoxAxis/adminEditPage.asp, line 6
My code:
<%
dim self, pid, i, c
self = Request.ServerVariables("URL")
pid = Request.Querystring("pid")
set Session("pageContent") = Server.CreateObject("Scripting.Dictionary")
Set custObj = Server.CreateObject("NFIFunctions.ValidateField") Line 6
set psi = Session("pageContent")
set errDict = Server.CreateObject("Scripting.Dictionary")
i = 1
Error :: Provider Error '80004005' Unspecified Error
i'm getting
Provider error '80004005' Unspecified error
admin/dbconnection.inc, line 4
what this is, it only started happening after i did a recent upload of my database!, i 've tryed uploading it again but the error still appears.
ASP Login
I have created a login and members page, and checked that it works, so that when you enter the correct username and password it logs you in.
But how can I have it redirect the user to their own personal page? Because I don't want to have different users going to the same page, I want them each to have their own personal members page.
Login
I've created a site where the user can register and then log in. However if a user registers, the data is entered into the database, but they cannot log in. But a username i entered directly into the database still works when logging in.
Does anyone have any ideas why this may happen?
Last Login
I get an error like this:
Type mismatch: '[string: "UPDATE dbo.con_users"]'
With the following query code:
UPDATE dbo.con_users SET last_login = #" + nowDate + "# WHERE username = '" + Replace(userUSERNAME, "'", "''") + "' AND password = '" + Replace(userPASSWORD, "'", "''") + "'"
I've successfully tested the variables in it (nowDate, userUSERNAME, userPASSWORD). What is the mismatch?
Login ..
I've already created a login page .. but how am i suppose to make sure that only those who login can access the member's areas and those who hasn't login will be redirected to login.asp ?? Is it possible to use cookies ???
View Replies View RelatedLogin
i am getting log in the application and woring with my some
windows.now keeping that other window open and now from that main window i am
logging out. so it throws me to the login page (as i am logged out). I
am also clearing and abandoning the session. also with the
FromsAuthentication.SignOut().
now with that login page i am relogging with other persons login ID.
Now i am taking the other window which i had kept it aside and now
refreshing it, it is showing me with the rights of the previous User.
I want it to redirest to the login page as it was open by other user
and now that user is not a vlid user as he has logged out.
ASP Login
Im new to ASP and im having trouble building a login script. I need an ASP login that reads the username and password from an XML page.
View Replies View RelatedI Have A Login
i have a login page and a page that validates it, if you log in succesfully i want to to display the name of the user on the admin page e.g i want to have "welcome and then the name of the user" how can i do this?
View Replies View RelatedAsp Login
i couldnt find this around the site anywhere.
i'm very new to asp
i am trying to have users be able to register, so they
need to be able to change the users.mdb file
adoCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("users.mdb")
they web browser says that i need to change that line of code so
it sends the password to the database so i can get access to it.
Login
i want to make a login session for 40 misnutes.so, what should i do.
View Replies View RelatedNT Login
How to get a user's name and email from
his/her NT login? I know that in .net, we can user System.DirectoryServices
to do so, but not sure if there's a corresponding mechanism to get info from
active directory.
Login
is there a way to limit a login, so that if a user "log's in" that username and password cannot be used until the user "log's out". peace.
View Replies View RelatedLogin
Im in the process of making a login script. I was thinking of doing
something like session("User") = rs("Username")
but how do I check if a user is already logged in or not ? I mean, if the
user isnt' logged in then the session variable isnt created and I would get
an variable error of some kind. Just looking for some input.
Web Login
I have a web based login form for secure login to access a member's area. Is there a way to pass a variable to ASP from the login window. I attatched a image of the login window.
The login form uses a text file to varify users. I do not wish to use ASP/Session for the login process.
Login With In 14 Min
I have a page where users enter information into a site and i have noticed a problem where some users take a long time entering the information. I have a timeout on logins of about 14 minutes but i need to extend this or get it to make the system think the user is still active while they are on this one page.
I have been thinking of using an AJAX solution to the problem, the reason for using AJAX is the logins are tracked in the database in an active users table and each time they change page the last seen time is updated. If the last seen is not updated they will be removed from the active users table and the system sees them as logged out.
could anyone tell me if using AJAX would this keep the browser session alive as if they were navigating through the site in a normal manner, rather than the session timing out or would i have to extend the browser session as well as updating the active users table in the database.
Login
I have a header section and the login.asp is included. When I click login I want the current page refresh. As the login fields are in an include this file is the one that refreshes. So if youre on default.asp and you login it opens up login.asp (which detects the session varriable and only displays the login fields if the user is logged out)
I want to know how to make this work. I know it can be done as Ive done it before (albeit many moons ago). All I really need is for the current page to refresh (if you are on default.asp and login it will reload default.asp, if youre on Contact.asp it will reload contact.asp)
Asp Login
can any one please give me simple login through database.
View Replies View RelatedLogin
I have a login page that asks for a usrname and password if this data exists in the database it creates a session variable for each then redirects to another page, this page checks the user sesion for a value and if it is not empty it displays the page or
redirects you back to the login page if the session is empty.
When I log in it displays the redirected page correctly but if I follow a subsequent link to another page (all pages run the same check)it redirects me back to the login page even though the two sessions are valid (I did a response.write to confirm the values) however if I log in again it lets me view all the pages correctly, what would be the reason that the first login seems to lose the session values but by logging in
again allows me to continue?
Login
how I could go about doing this? Also is there a way to export all the users and there passwords in Active Directory into a *.csv file or something silmilar that I could just put in a database and pull from?
View Replies View RelatedLogin Question
Can someone explain the how I can make it so that a login ( username )
can only be logged in once to a website if it is possible.
What I would like to do is have it so that if dwaldman is logged in
that login can't login again with another session until the old
session is terminated ( logged out )
Function-Last Login
i want to display the last login time and date in my portal.asp but however i search thr w3school.com and try out but still unable to do.
View Replies View RelatedLogin Without Cookies
I have created a website that uses cookies to check to make sure that someone is logged in on secure pages, but some people have e-mailed me saying that they cannot get in. It is because they do not have cookies enabled. A NEED TO FIND A WAY TO CHECK THE LOGIN ON SECURED PAGES WITHOUT USING COOKIES. It would be nice to also be able to know who is online and where they have been - maybe an activity log.
View Replies View RelatedLogin Without Cookies
Does anyone know how to create a login system with ASP that does not use cookies? I am finding that more and more users seem to be setting their privacy settings to high, thus not accepting cookies.
What I am thinking about is to have some type of server side session that when a user logs in, I write the session ID to a database as well as the user ID so that I can keep track of the users that are loged in.
I have played with regular sessions, but if a user does not have cookies enabled, the session do not seem to maintain state and are basically useless.
Login Not Validating
I got this login script and I edited it all and it seems to
run fine...IE it listens to the script as far as permissions go when I
place a restriction on a page and when you login it redirects. But
first it doesn't tell you that you're logged in and doesn't provide a
logout feature.
And most importantly if I type in a random username and password not
listed in the database it doesn't seem to matter it still "lets me
login"
I think it may have something to do with my database connection. I
am using an SQL database/server ADO connection. But I don't know if
I entered it right in the code. Code: