I'm using a ACCESS database that has a databasepassword. In the connection string I'll provide the password as follows:
MM_test_STRING = "dsn=test;pwd=test;"
This works fine on IIS 5 but on IIS 6 on Windows Server 2003 I'll get the
followwing error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid password.
When I'll remove the password the DSN works fine also.
Is this sql statement valid?
strQ = "SELECT *"
strQ = strQ & " FROM Receipt"
strQ = strQ & " WHERE Receipt.Expense ='Inventory' AND Receipt.ReceiptDate Between #1/1/2005# And #12/31/2005#"
strQ = strQ & " ORDER BY Receipt.ReceiptDate"
What I like it to do is select all references to "Inventory" under the field Expense for the entire year of 2005, with the results sorted by date ascending.
i downloaded soem code that is a way to view a MS access db with asp. The error I get is Not a valid file name. Microsoft JET Database Engine error '80004005' . I know it might not be enough information, but anyone have any clues? Code:
View Replies View RelatedIf you use ASP.NET you can still make valid xhtml code right? Becuase Visual Studio .NET 2003 doesn't care if it's <br> or <br /> thats bad in my opinion =) You know if Whidbey will make better xhtml?
View Replies View RelatedThe field name 'articleid', which is an identity/primary key , is not being recognized in my recordset as I get an " Item cannot be found in the collection corresponding to the requested name or ordinal" error with the following- the line number that the error message points to is on my response.write for the rsid("articleID") :
dim sqlid,rsid
sqlid = "SELECT max(ArticleID) from tblarticles"
Set rsid = Server.CreateObject("ADODB.Recordset")
rsid.Open sqlid,sqlc,3
response.write rsid("ArticleID")
I want to use validation with my ASP script before i add a new record to the database.
Code:
if UserID = "" then Response.redirect("login.asp?login=createnameEMPTY")
so far it only checks that the field is empty- how would i also check that the field is just letters and numbers or if the email field is valid?
When I'm trying to start the smtp virtual server the status of the smtp server is showing 'the requested Control is not valid for this service'
Its state is shown as unknown.Wat ay be the reason.
The messages I'm sending is going to the pick up directory from there its not taking
Is this a valid name for a session variable:
Session("mySessionName:$SO")
If so, does the " :$SO " mean anything special? I'm going through a web application written by somebody else (who I don't have contact with...) and it's littlered with these types of session variables.
I have one asp page in which i ask the user to enter the path. This then transfers the control to next asp page. In the next page i want to check whether the path is valid or not. I know there are methods of FileSystemObject like DriveExists, FolderExists and FileExists but these has to be used individually.
Suppose the user enters the path as "D:" then i should use DriveExists
and if the user enter the path as "D:/test" the i should use FolderExists
i.e i have to use individual functions. How to check this using one function only
Another problem is that i want to display the message on the page for some seconds and then the control should transfer to next page. How do i go about it.
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?
I use the following code to chck for a working url. It does work for some, but sites that seem to be written in PHP, and google, seem to return a "fail" - I can't figure out how to get p-ast this.
Dim objHTTP
Dim sHTML
Set objHTTP = Server.CreateObject ("Microsoft.XMLHTTP")
objHTTP.open "GET", strURL, False
objHTTP.send
sHTML=objHTTP.statusText
if err or sHTML<>"OK" Then
sTxt="fail"
else
sTxt="ok"
End if
Set objHTTP=nothing
else
sTxt="fail"
End if
Say I retrieve and e-mail adress from a form like this, then I know how to check that it's not empty, contain numbers etc. but I don't know how to check that the e-mail complies with some kind of regular expression or the like.
Therefore I wonder if you have any good e-mail form validation code that can be used on the server side (comparable to Java Script reg.exp on the client side).
<%
Dim mail
mail = request.form("email")
IF mail = "" or mail does not complain with some kind of reg. exp THEN
some code....
End IF
I created sessions to authenticate username and password. How can I utilize this same script to alert the user to change password at 3rd login? In other words when a user logs into a site after the 3 or 4th time which ever, they are prompted to change their password. Code:
View Replies View RelatedI am now all of a sudden getting an error in this sql connection
string, saying that the Provider keyword is invalid:
<add key="MM_CONNECTION_STRING_isox"
value="Provider=SQLOLEDB;SERVER=xx.xx.xx.xx;UID=xx;PWD=xx x;DATABASE=xxxx;"
/>
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Not a valid bookmark.
has anybody seen such types of errors?
how to write to check verification valid email thru nslookup or mx record or dns record. Is it possible to do that. Is there any tutorial from sitepoint, previously found it but i lost the link.
example to check assume test@domain.com is not a real email, abc@domain.com is real email
how do u check it.
where do you enter in the password for the connection to use?
set objConn = server.createObject("ADODB.CONNECTION")
objConn.Provider="Microsoft.Jet.OLEDB.4.0";"Password"
?
I am logged into nt and running an asp page.
I know that I can get my username from the server variable LOGON_USER or
AUTH_USER but the AUTH_PASSWORD seems to be empty.
Is there a way to retreive the current logged passsword
I just setup a passwrod button in Outlook Web Access by using the IISADMPWD directory in IIS.I have a few problems.can u solve it.
1. I would like the account section to be automatically filled by IIS.
2. I would like the back button to actually be a button not a link.
I have created one of those change your password forms whereby the the old password and new password are provided.
What I am having trouble with is ensuring that the old password entered actually exists already. Below is what I have tried, but I am getting a syntax error:
Code:
'Check Password
if request.form("CusPassword")<>rsCheckUser.fields("CustomerPassword") then
response.write "Invalid password"
end if
Else
if request.form("CusPassword")= rsCheckUser.fields("CustomerPassword") then
'write new password to databasestrSQL ="UPDATE Customer Set CustomerPassword ='"& NewPassword& "',CustomerPasswordverified ='"& NewPassword& "' where CustomerEmail = '"&CusEmail&"' "
I want to create a password validation system..... There are two text boxes.... I want to make sure that the passwords are the same and that they are more than 8 characters.
View Replies View RelatedIm planning to encrypt the password that was stored on msaccess database and
also the text inputed from a password textbox. Also, if I want to get the
password from the database, I need to decrypt it so it can be comparable to
the one that is inputed on the textbox. Is there a way on how to handle
this?
Public Shared Function Encriptar(ByVal cleanString As String) As String
Dim clearBytes As [Byte]()
clearBytes = New UnicodeEncoding().GetBytes(cleanString)
Dim hashedBytes As [Byte]() = CType(CryptoConfig.CreateFromName("MD5"),
HashAlgorithm).ComputeHash(clearBytes)
Dim hashedText As String = BitConverter.ToString(hashedBytes)
Return hashedText
End Function
this function encrypt user password, I need to un-encrypt that password
thanks to sitepoint forum,i am requesting a problem about forgot password .
if user forgot his/her password how can i retun his/her same password in email address?
i did like this:
......................
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="your password"
myMail.From="codes"
myMail.To=ml 'ml var return current email address
myMail.TextBody=yrpass 'yrpass variable return password
myMail.Send
set myMail=nothing
%>
...................
does anybody here have codes for "change password"?i am using dreamweaver 8 and MS Access
View Replies View RelatedI have a form and iwant to check if the password which gives the user is between 3 to 6 characters "alpanumeric" there is something in asp code to do this?
View Replies View RelatedAny thoughts on requirements for a password?I've been thinking about
the following
Minimum six characters
Must contain at least 1 number and at least 1 letter
Cannot contain the user's first or last name
Cannot contain the user name of the person's email address
Cannot contain the domain name of the person's email address
My form accepts user name and password. I want to encrypt the password when I send it to the server. I think I can use windows advapi32.dll functions to encrypt and decrypt the data. Does anybody know if I can use this dll directly in my asp? Do I have to write customized dll which uses advapi32.dll and then use the customized dll in the asp?
View Replies View Relatedi wanted some help in the bewlo subject i tried in different code but some time it is showing wrong error.is anybody give me the example or site linke where i can donwload the the password checking script from database.
I have pulled data from database and shown those user name in suer tab ( drop dwon box) user need to select the his name and to type password.once user type the password it should check with database . if it exists then it should capture that user name and move on to next page.
How to use WIndows XP login username and password for ASP 3.0 Authentication, for access to a website directly without any further, second authentication by ASP page?
I have MS SQL Server database, ASP 3.0 website, and ASP 3.0 based authentication. I want to use a Windows XP username, make a table with approved usernames, check Windows XP username and password against the mentioned table, and finally - user can access the site without second authentication by ASP page. Of course - everything should work in IE.
I am using OE6. Instead of using the Main Identity, I'm using another one;
it helps cut down the spam. Somehow it switched back to the Main Identity
(I didn't fiddle with it) and the other is password protected. Either I
have forgotten that password or it isn't responding. How can I recover the
password, which is where all my legitmate email is found?
i have new task again.. and i dont know where to start. maybe it seems easy to all of u but i m new and still learning.. so pls forgive me hehee..
i was told to make serveral changes to their shopping cart.
1) Upon user's first login, the system will prompt the users to change their password.(which means every user share a default password tats y they mus change)
2) The system will prompt the user to change their password every 90 days.
3) The System will allow the users to change their password to the same 1 for 10times.. after which.. they cannot use back
the same password again.
4) Every password change must be saved as a log into the db..
yah thats all abt it.. but it actually links from 1 to another.
I am trying to write a little script to return a users password, but am getting an
error message : "Email address you entered could not be found.The details entered were incorrect." What am I doing incorrectly? the password is in the DB Code: