Verify MSSQL User/Password/Database Combination
I am currently writing a little gadget where users can create, delete, alter... tables in a database. Some kind of MyAspAdmin... Everything works fine as long as I specify the MSSQL-Login-Infos database, user and password.
But if I want to make it possible to switch from one database to another, here comes the problem: The user has to choose a database that he wants to work in, and type in user and password.
I need the (probably very easy) solution, how i can check if this user/password/chosen_database combination is correct. Code:
View Replies
ADVERTISEMENT
I'm working on a site which is password protected using ASP and an Access database.
I need to require that new passwords be at least 8 characters and contain at least one character from upper case, lower case, number and special characters. I've searched but haven't found anything that looks like it would work - only scripts to prohibit certain characters.
function mt_valForm(val)
{
var passed = true;
var mt_error = '';
if (val.txtusername.value == ""){passed=false; mt_error+="Please provide a user name
"}
if (val.txtpassword.value == ""){passed=false; mt_error+="Please provide a password
"}
if (val.txtemail.value.indexOf("@") == -1 || val.txtemail.value.indexOf(".") == -1){passed=false;
mt_error+="Please provide a valid email address
"}
if (mt_error!= ''){alert ("There were errors - please correct these:
" + mt_error)}
return passed;
View Replies
View Related
I have a form which accepts the username and password. I am storing it in an Access Database. How do I check if the user already exists in the database by passing SQL queries? Could someone possibly give me the code or maybe a link.
View Replies
View Related
Is it possible to create a blog on Asp?how can i create a page where you can't access unless log in by user name and password. Link to tutorial works just fine for me!
View Replies
View Related
it is possible to get the name and the password of a system user? E.g. I have a login page and I have one user on my server myserveruser1 which has the password "pass1"
The web user iserts the username and the password in the login page: can I check these fields with the user on my server (if user inserted = "user1" and pass inserted = "pass1") then ....
View Replies
View Related
Is there a way to supply a nt/windows user/password combo in a url for an
automatic login to a nt user/password secured site?
Something like
http://mysite.com[?]user=me[?]password=mypassword
[?] = some sort of marker like ":" is for the port #
View Replies
View Related
I lethe user enter a username and password and through a SQL-statement I
check if there is a corresponding password in the database (Yes I know,
not very good security but for the moment it's enough). Problem is that
when I enter a false user/password, I want the code to redirect to
another .asp-page which states the user is not valid. Problem lies
within the statement "if rsMOS is nothing then response.redirect
"VWGloginAgain.asp" ". Somehow, the code does not return 'nothing' but
something else.
How do I figure out what it returns? Or, how can I make sure it returns
a 'nothing' when no such password is found in the database?
Here's my code snippet ('usr' and 'ww' are defined earlier; furthermore
I've left out the redirects, but I've tested the first
if-then-conditions and they work fine... Just the 'nothing' does not
work):
View Replies
View Related
i have created a page for users to enter their details into a table,i.e. name, e-mail address and password,i also want these + other details to be e-mailed to the user when he clicks the submit button,how is this done?
View Replies
View Related
i need web based mssql database manager.
features
create table
edit table
del table
add-del-edit records
and free
View Replies
View Related
What I need to do is connect to my database server from my webserver [which are both in my LAN] and bring back some data and allow the end user to search through the data.
Is ASP the best way to go about this?
View Replies
View Related
if it's possible to allow regular windows domain users to change their passwords through an .asp page? I'm trying to figure out the best way to handle domain users to log into an .asp application tied with SQL Server 2000 on the back end since I keep reading that windows authentication is better practice to log into SQL Server.
View Replies
View Related
Could anyone provide asp.net code that would generate an automated email containing a users password from a database when they submit there email address. Any good sites on the subject either!
View Replies
View Related
I'm trying to access an access database by including the DB's password within the connection string. I try to connect to the DB, but I get and "Incorrect Password" error. What am I doing wrong?
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"; uid=admin; pwd="pass"
conn.Open(Server.Mappath("maindb.mdb"))
set rsUpdateEntry = Server.CreateObject("ADODB.recordset")
View Replies
View Related
By using <authentication mode="Forms" > in web.config, we can create
self-designed login page, but how to check user's account and password is
vaild in another domain controller?
Does <authentication mode="Windows"> can have self-designed login page?
View Replies
View Related
how to create asp spry type horizontal menu that is populated from a mssql database. Only able to find help for asp.net, need help for strait asp.
View Replies
View Related
I am having a hard time figuring out how to sum records in an access table, and display them correctly with asp on a web page.
Here's an example of my table:
Organizations
orgID, orgName, noPeopleInvolved, noHoursWorked.
This table just keeps track of the number of volunteers an organization had at a particular event, and the number of hours the organization as a whole, put in.
Now, I can get it to where I display every single organizationName once, in a table (an html table on a web page), with columns OrgName, Tot People Involved, and Tot # of hours worked,
by using this asp code and getting each orgName from a basic select statement earlier in the code:
View Replies
View Related
I hope someone here would know this question. Given an area of a city whose 7 digit phone numbers are prefixed with 584, how many different combinations of phone numbers could result from that? So, it would look something like this:
584 - _ _ _ _ with the digits being between 0 - 9
I came up with 5,040 possible combinations
by doing 10! / (10 - 4)!
Is this correct?
View Replies
View Related
I have an ASP page where I am building a query to get the data from the
table. I am using Microsoft Access and ASP
The table has three columns Id, StartDate, EndDate.
For each record the users only enter either the startdate or enddate and not
both.
When i am writing my querystring I want to sort my results by date but the
date should be a combination of StartDate, EndDate
I tried something like this
SELECT * FROM Table ORDER BY NZ(StartDate,EndDate)
This works in the database directly but on the ASP page it does not allow
the NZ expression.
View Replies
View Related
We have a customer who uses utf-8 encoded websites and wants mailto-link on some websites with integrated subject/content.
Website is written in ASP (.NET is not available at customer site).
So according to RFC (as far as I could interpret it), we created a mailto-link like this: ....
View Replies
View Related
I got this error.
Microsoft JET Database Engine error '80040e4d'
Not a valid password.
/zbgamers/login.asp, line 13
here is my code:
Set DB = Server.CreateObject("ADODB.Connection")
Set TBL = Server.CreateObject("ADODB.RecordSet")
DB.Mode = adModeReadWrite
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" + Server.MapPath("DSN_CSG.mdb"))
View Replies
View Related
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.
View Replies
View Related
I am new to ASP security. I want to know what is the best way to store
database password in ASP application? Or if there are any places to
store in IIS? I tried to store the password in VB DLL file, but looks
like when I open the DLL file, I can still see the plain text password.
View Replies
View Related
I would like to know something about placing a password for a database in an external file, something like a global.asa file or a included file. I'm using an access database and ASP. how do I make this file and how do I attach it to my website. I thought this might be useful for extra database security, is this true?
The database is located in a folder that is protected by the hosting provider and you can only download the database using a login name and password and you can change data trough webpages (update, delete and insert).This has all about database security, I want to make my database as secure as possible, I'm already using SSL certificates.
View Replies
View Related
I am trying to create a "Members Only" section of my website. I have an Access Database to store usernames and passwords and I am using Frontpage 2003.
I have very little ASP experience and am having trouble finding some help on this subject that is understandable. I already have a global.asa file on the site because I currently have a page with a form that writes to the database.
What I would like to know is how to setup a login screen to get to the members only side of the site which will validate against the password table in the database.
View Replies
View Related
I am working on a CMS website which uses a access database.
When a user adds a page a record is added to a table in the database. The user choses the page style from a selection of 7 or 8 layouts.
I have been asked to find out if I can password protect one of those pages??
I have tried a few sites but not found much. The it has been done before is to add a password protected layout and build a login area into the site.
The effect i want is for the user to click the page and a username and password box will apear?
View Replies
View Related
I'm having trouble verifying the cookie that I leave on a client's computer.
Here is the code: ....
View Replies
View Related
How do i verify if the value of a variable is a number or a string? because i want to insert it on a field that only supports numbers.
View Replies
View Related
how can i verify that an image is true?it has to be something like:
<% if %>
images/<%=rs("productid")%>.jpg
<% = true
then response.write("<img src="images/<%=rs("productid")%>.jpg"")
else response.write("<img src="images/nopicture.jpg"")
end if
%>
View Replies
View Related
I'm looking for a code already written if it is possible (as i need to do this soon)I have a database(access) and the users submit data from a asp page and it stores the values. Then it also allows the users to login to the web page using the data (username and password) inserted by the user.
What i want is that when the user logins, to be able to modify the inserted data..Perhaps the user wants to change the e-mail address. I tried doing some search in google but the results were no good.
View Replies
View Related
I have been thinking about storing some data, which my users upload, in text files rather than database, since often I do not know how much information users submit for things like item description or images URL paths.
This information may be very short or very long. MS SQL Server requires a maximum field length to be set. Thus, if user enters 5 characters into 5000 character field, a lot of space will be wasted. On the other hand, the database reference would point to the text
files to read users' data and display it on page.
View Replies
View Related
I found this bit of code on the forum which illustrates how you can get NSLOOKUP to check you email is valid.
Code: .....
View Replies
View Related
I have a webpage where there are two drop down menues. From each of them, one item can be selected. I need code to test if there was an item selected from both the drop down menus. How do I do this? Do use ASP or HTML?
View Replies
View Related
Is there some function similar to isDate() that can be used to verify times entered.
View Replies
View Related