I am using visual studio 6.0 (interdeav)

How can save password in the sql server 2000 in Encrypted form ?
So that no body (administrator also) can not see the password.
administrator can change or delete the password but not see.
It is possible in sql server 2000 ?

There is any method that save password in secure way in sql server 2000 ?

In sql server pw field data type is varchar

Asp code is

<TR>
    <TD>Contract No.</TD>
    <TD><INPUT type=password id=pw name=pw></TD></TR>
  <TR>



Second problem in Date format

When I save date format like this

Day-month-year it give following error

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E07)
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
/dcilweb/sas/add_cont.asp, line 48

If I save date in year-month-day format it save the date, not error,

How can I change date formt day-month-year ?


Mateen

I just implemented this on a user login table in SQL...

You would typically, encrypt the password before storing into the table. Depending on your programming environment, you can search for a number of encryption routines. My personal preference is AES but the source code might be difficult to find for other than C++.

There is also the RC4 algorithm which can be readily found but far less secure.

As for the date problem, you might try to validate the date field entry before storing into the database field...

thanks for your response.
some one inform me about the encryption routines address is

http://aspnet.4guysfromrolla.com/articles/103002-1.aspx
(it deals with ASP.net, I will get the idea).
Javascript version of MD5 http://pajhome.org.uk/crypt/md5/

how I can validate the date field ?
you may give me syntax ?

My another problem is that
when I save the entry (contract.asp) it save double values
in the table, I check my query in sql analyzer, there
is no problem, by the sql analyzer it save single record.

why it save double records by the asp file (contract.asp)
in sql server table ?

Please check the code is following.


isql1="insert into emp (empno,fname,mname,lname,posit,dept,strdate,emptyp e) values ("
isql2="'" & empno & "',"
isql3="'" & fname & "',"
isql4="'" & mname & "',"
isql5="'" & lname & "',"
isql6="'" & posit & "',"
isql7="'" & dept & "',"

if IsDate(strdate) then
isql8="'" & strdate & "',"
else
isql8="NULL,"
end if

isql9="'" & emptype & "')"


sql=isql1+isql2+isql3+isql4+isql5+isql6+isql7+isql 8+isql9

cn.Execute sql

cn.Execute sql
if err.number=0 then
Response.Redirect("add_emp2.asp")
else
Response.Redirect("add_emp3.asp")
end if



regards.

Mateen

I think you're overlooking the obvious. You may either need some coffee, or some sleep ;) The SQL statement gets executed twice, so you get two records.....

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

thanks.

date format problem is there,
how can validate the date dd/mm/yyyy in ASP ?
how can save date dd/mm/yyyy format by the ASP ?
any asp code ?



yes I need some coffee.

Mateen