ASP :: Verify MSSQL User/Password/Database Combination

Verify New Password Meets Format Conditions
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;

How To Verify A User Using Sql Queries
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.

User Name And Password
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!

Mssql Database Manager, Web-based
i need web based mssql database manager.

features
create table
edit table
del table
add-del-edit records

and free

Nt/windows User/password
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 #

False User/password
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):

E-mailing A User His/her Password
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?

Change Domain User Password
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.

Automated Generated Email - For User Password
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!

Correct User, Password Sequence For DSN-Less DB Conn.?
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")

Mssql Database Driven Spry Type Horizontal Menu
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.

How To Check User Account And Password In Another Domain Controller?
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?

Combination SQL And ASP Coding
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:

Number Combination
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?

Search On Combination Of Two Columns
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.

Password Login + Database
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.

Best Way To Store Database Password In ASP Application?
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.

Database Password In An External File
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.

Encoded Mailto-link In Combination With Outlook
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: ....

Password Protecting Single Pages In Access Database Cms System
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?

User Modify Database
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.

User Database Access Rights
Is there any way to use asp to determine a users SQL Server database access rights.
I.e I have given a users data read only/ data write only in SQL server, how can I pick that up in an application so that only write only users can see a hyper link.
I know I could create a few more pages with a table in a database with various rights but I just want to read rights directly allocated from SQL Server.

Individually Password Protect Multiple Directories? Password Expiration?
I have a client who wants to password protect a learning course that is set up in modules. Each module needs to have it's own password protection so users can only access them as they progress through the course.

Each user should have their own password (for each module) and, said client would like the password to expire for the user at some (predetermined?) point. Is this possible? It seems like a lot (in terms of setup), but I don't know much about password stuff.

If it is possible, can someone give me an overview of how it works (theoretically) or where to find more specific info on setting something like this up (in ASP.net)

If it isn't possible, can someone suggest what is more reasonable in terms of protecting the modules?

Verify Cookies
I'm having trouble verifying the cookie that I leave on a client's computer.

Here is the code: ....

Verify Value Of Variable
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.

Verify Image
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
%>

How To Stop User From Booking When The Database Is Empty.
I am writing a small ASP booking engine which allows users to book a ticket provided the num_tickets field in my db table is > 0. Each booking causes the num_tickets field to be decremented. So if a user tries to book when there are no tickets left he gets an appropriate error message. However, if a user books the last remaining ticket and the num_tickets field is set to 0, he can simply hit the "back" button and book again (which decrements num_tickets to -1 and so on). Is there a way I can make the page refresh or expire to stop this from happening? is it a sessions problem?

NSLOOKUP To Verify Email
I found this bit of code on the forum which illustrates how you can get NSLOOKUP to check you email is valid.

Code: .....

ASP Or HTML? To Verify Selection
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?

Verify Time Input
Is there some function similar to isDate() that can be used to verify times entered.

Verify Digital Signature
Is there a way in ASP to verify digital signature by using one of
public keys contained within the application's PSE (Personal Security
Environment) file?or if this is not possible, can it be verified by using the public key
itself, the CRT file?

Verify MIME File
How verify MIME type of file? Which components should I use? Still now I couldn't find anything. I don´t to check file extensions.

Redirect If User Exists In Database - Having Problems With Apostrophes...
I have a page where students can choose activities in a day... this then directs them to their timetable for that day.

However, if they go back to the choose.asp page and they have already registered, I redirect them to timetable.asp - because I don't want them to change their options.

I have their username stored as a session variable and it works fine for most students - however for the example student O'SMITH-JONESMark the page falls over.

I am using Dreamweaver's 'redirect if username exists' server behaviour. Code below... Can anyone tell me how to fix this so the code is not tripping up over the odd characters? Code:

Code For Collecting User Ip Address/date Into SQL Server Database
I need code to capture a users ip address once they agree to a disclaimer (a form yes/no). If the user states no a message telling them they do not have access and a redirect back to the home page.

I need to put the ip address along with the date a sql server database. I am lost as to how to code this and also how to set it up in my directories.

Verify Type Or Extension Of File Using ASPUPLOAD
How verify type or extension of file using ASPUPLOAD? I check documentation, but I didn't find anything else yet.

Mssql
I have imported a list of links to MSSQL database with enterprise manager. I use ASP to show the list of links and it's description. Originally I had 8600 links in the database and I have imported 700 new one.
I have checked in table and all the links exist and the table is indexed on field linkID. My asp script has worked before and there is no problem with it.
I can still show all the links including the new links and it's descriptions but if I click on an old link, it goes to that site while with new imports, it just opens another example of my site (404 page set to open my index page).
The link is correct since if I copy it from screen and paste in browser, it opens the page correctly.I have removed the index from table and made it again but no difference. There is also an edit function in my script, if I click on it, I will get a message that filed linkID does not exits but it clearly exists in the table and the rest of script is using it.

ASP And MSSQL
If I creat a ASP page, what do I need or how do I connect to a MSSQL database? Is it possible to connect to MySQL with an ASP page, or is it better to stick with MSSQL when creating an ASP page?

Call MSSQL Job Using ASP
Does anyone try before using ASP to execute JOB in MSSQL?

ASP (Javascript) And MSSQL XML
I was wondering if anyone could give me some pointers as to using ASP (Javascript, not VB) to get XML out of SQL.

I have my storedProc with the FOR XML AUTO on the end, and that is returning a recordset with XML fine in query analyzer.

I am lost as to how to output this as XML from an ASP page so I can transform it with XSL.
My transform would be something like: Code:

Stable ASP/MSSQL CMS Out There
Looking for suggestions on any stable asp/MS SQL server content management systems in the market place. Any suggestions, or even places where I can look? I have quickly seen Rainbow and would like any comments from users of this CMS.

ASP/MSSQL Version
I am currently learning ASP but have a small PHP background,
With PHP I used PHPMYADMIN to work with MYSQL
Is there a web based Alternative for
ASP and MSSQL that provides similair functionality?

ASP/VERY COMPLEX MSSQL
I have a query to one table but one of the values in the table is referencing a record from another table... here is the sql Code:

strSql = "SELECT streetdate, barcode, itemname, descrip, vendor, sku, catlog, config, retail_cost, cost FROM blah WHERE (STREETDATE >='"& GSTARTDATE &"') AND (STREETDATE <='"& GENDDATE &"') ORDER BY STREETDATE, CATLOG DESC"

now I have 2 things going on here...
1. vendor is just a number... there is a tblvendor that matches the number with a name (that i need.. i coudl nest another db query but figured that would be more resource intensive as this returns 1000s of records)
2. itemname is also a number that references another tblItem the sam way, I woul dlike to sort alphabetical off this somehow (is it even possable)

Update Mssql Using Csv Or Xml
Can't seem to find anything relating so forgive me if i've missed it.
I'm after a way to open either a csv or xml file, then cycle through each line to see if it's in mssql, if it is update it... otherwise add it and then if it's in mssql and not the csv, remove it.Is it possable?
Still learning and haven't dug into opening files, let alone this so any help would be grateful... oh and the fields are exactly the same in both

Asp MSSql Hit Counter
Anyone know of a free advanced mssql hit counter?

Connecting To MSSQL Db From Web
In our office we use RMS (Residential Management System) and they use an MSSQL database to store all the data. we can access this database using access and have made several...several queries to pull out info, save it to another access database, then upload it to the web and pull data from it.

the server that houses the MSSQL database is online and i was wondering if it is possible to connect to it and pull out information. we wouldnt want to change anything, just view.

so to connect to it, what all do i need to do?

Access Vs. MSSQL In ASP
I'm just deciding whether to use Access or MS-SQL for a web-application

I'm predicting that my application will grow large enough to warrant use of MS-SQL, but I'm wondering how extensive the changes to my code that would make

...Specificially in ASP.Net, if I use ADO.Net, would I just need to modify my connection string or would it involve more extensive modifications?

Stored In MSSQL
I am new to programming and I managed to store images in MSSQL.
The problem I have is that when I retrieve the image from the database
and display it in my browser it opens a new window. I would like to use
the image control, but it requires a url. Is there anyway of viewing that image
in the image control or keeping it in the same page where my information is
but displaying it where and when I want it

Can Run MSSQL DB In Linux
I want an answer by tomorrow with examples and reference URLS if we can do this.There is a program written in ASP and the databse is MSSQL (Microsoft) hosted in Windows platform.
But they want this databse and ASP Program host on a UNLIX/LINUX server and use the same ASP program. Can thy do it/ and how?