I am trying to build a secure web login that allows me to identify the person logging in by a "Welcome user" message that comes up when they reach the destination page.
Also, I want the person to be able to update their personal info and such when they are in the site. I know how to update a record, but I am unsure as how to tell the database which record to update based on the person who is logged in.
Unless you declared those session variables earlier, they have no data in them. Assuming this information is coming from a form, try using request.form("fieldname") instead of the session variables.
If this doesn't address your problem, give more detail about what "isn't working"
I have a website which requires login. The login function works fine, but I want to display this message when someone is logged in: "Welcome, Firstname Lastname". Here is the code for login.asp: Code:
I want to limit user login by writing ASP program. In details, if a user had logged in wrongly for more than three times, then the user will not be abled to log in to the system anymore even thought he key in correctly the username and password in the 4th time. That's means he cant login forever until the administrator edit his status in the database Can i refer to any ASP sample coding for this application?
I am looking for a simple code of login to db of asp dotnet (vb dotnet code). with user name + password & simple database. When login to database - I want to see a table data with all it's columns.
I am trying to connect to a database and verify a users login and password, then based on that login information display 3 pages based on their login.
On the home page if they are NOT logged in, I need it to display the login box, if they ARE logged in I want it to display Welcome Customer Name from a database called vcust.dbf which contains both the username and password fields.
The two other pages will be based on the username (which is actually my customers customer number ... example '100001'). I am needing to display the customers account informaiton on one page from the vcust.dbf and their rental history on another page from records.dbf. Code:
I am introducing a password login script to my site.I know how to password the site but am looking for good ways to password protect to users can only access their details and no-one elses.Also i was wondering whether to use SSL or not.
First my database consists of a couple tables.MyUsers (records - username, password, tablename)User1 (records - record 1, record2, record3)User2 (records - record 1, record2, record3)
What I have a username and password login. When they login I need asp to look up in a database (table - myusers) and if the username and password match one of the records then take the third record (which is actually a reference to that user own table) and store it in a variable.
I then need to read that users table and display all the info in that table on a new page for only that user to view.
Below are the files that I have. I have been messing around with it with another example so some of the code might be a little misleading....
I want to move my only window shosted client to linux. The site they have access a Microsoft Access database with the below code but i can't get it to work under Linux.
I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:Collect.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ".
The 'F:' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
I'm looking to make an online multiplayer game which will utilize Access Database... basically I require thousands of people writing and reading from the same database... I was wondering if this is possible for that... or is mdb file restricted to 1 person at a time...
If it is limited what would you suggest as the best way to control an interactive online environment? .txt files possibly?
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:
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?
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
I have four input variables from a form (first name, Last name, registration number and pin number). I want to check if this variables conform to the data I have in a database (mind you the Pin number is initially not related to the registration number, first name and last name and it is a list of numbers in a separate table in the database;I want to have the flexibility to supply any Pin number, tie this number to the registration number, first name and last name for the purpose of accessing other data in the database for a specified number of times) . how can I do this in an asp environment ?
I'm trying for the longest while to access a database and i keep saying error 3219 which states that the operation is not allowed in this context.
The error occurs when i add obj.AddNew. I have declared a variable called obj which handles the microsoft access database. i set it to obj.Open tablename, connection,0,3,2 and after assigning the values to the fields i then said obj.Update.
I'm creating a form for users to fill out and submit the form via email(outlook). But at the same time I want their names and phone numbers to be registered in an Access database(once submitted). I can't figure the ASP coding to do this.
I have a whole database set up in MS Access with all the menus etc. It's a flight reservation database for a school project. Is there a way to import everything (including the interface) to a website using ASP or ANY other kind of software?
i want to write a intranet webpage (can be in ASP / HTML) to connect our Access Database and to search in the Database. We are using WinNT Server here, and php is not allow. And i have no permission to install anything to the server ... I have experience with php and mySQL, but have no experience with asp ... 1. what is ODBC ? how to link db with ODBC in intranet ? (coz' i only saw instructions to link db to local computer) 2. any sample codes of ASP with access database to follow?
Hope that i could find my solution here.i'm working on an asp page and i need to display data from 2 different databases one is in sql server and the other is in access currently i have linked the sql tables into the access database but problems occur where i have to refresh the tables regulary so what i need is to be able to select from the sql and access seperatly in one select statment How could i create the connections for both of them to be able to do so?
What code do I use? Bear in mind that each ACCESS record has an Auto-ID, but since some records may have been deleted, the number of records in the database does not equal the maximum ID number.
For a new project I just got,I am being asked to code a small web site but it has to be in ASP. The company doesnt have alot of money, and wants to use ASP and an Microsoft Access database.I had thought that ASP was only able to use MS SQL, but maybe that is wrong.
I am very adept in PHP and MySQL, and have programmed a little in ASP, but never with ASP+ and a database. Could someone please recommend a site or give some examples on using ASP with MySQL or with Access?
I am trying to get records from an Access database that can be viewed from a WAP enabled phone.I understand that I have to create a WML file, but dont know how to do this.
i have a form that adds subjects to access Database.It works very well but the problem is when i request the fields by their Name and not by Id. If the subject have to 2 words or more between the 2 words, there is Space so it take Only the First Word and ignore the rest of the words.
they have a database which stores information about their properties.. as well as one image of the property from the outside and 3 or interior images of the property.they would like the 'property' section of the website to pull the images and descriptions from this database.
they would also like to edit the properties section on a daily basis using forms.. (deleting properties.. adding properties.. deleting images.. uploading new images.. ) does this sound viable in asp and also some tutorials on uploading files i think will benefit me.
I have a single table, with 8 fields. I want to allow users to filter their selections on 3 fields, specifically County, DistrictName, and Date. I would like users to be able to chose one a specific field from each of these 3 or default to all. Users will not be able to update the database, they will simply be returned data.
Add to this one of the fields is an amount field in which a user can see the sum of the data returned. In conjunction I will also need a flag for amounts which have not yet posted so that these do not report in the sum amount. I would be most grateful for any assistance or if i can be pointed to a product which will aid me in completing this task.
How can I secure an Access database that I use on my Web site? That is, I don't want users to be able to guess the URL of my Access .mdb file and download my database.
I can't insert records from a form on one of my pages that has SSL on it. It encrypts the data and so then I get a microsoft jet error saying data type mismatch. Is there any way around this. or am I doing something wrong?
How can I give "write" privilege to the database to the visitors of my website. I want them to upload their personal information and photoes instantly. I am using MS-Access. How am i supposed to set the configuration? Is the web-hosting company responsible for it and which software to use for it.
I have database containing the results of students in MS ACCESS.I have created form containing one textbox for entering the roll number of students and two buttons -SUBMIT and RESET using HTML .
Now I want to access database from this HTML File using the textbox and SUBMIT button so that details about the particular student whose roll no. is entered in the textbox, is displayed on another HTML page using ASP.