encrypting passwords in a database

Visual Basic General

‹ Visual Basic
- Archive
  - Windows Vista
  - Visual Studio
  - SharePoint
  - Dotnet
  - VB
  - Visual C#
  - VS 2008
  - Windows Live
  - VFP
  - IE
  - VS Express
  - Office
  - ISV
  - Game
  - Smart Device
  - VC++
  - Architecture
  - Windows Forms
  - SQL Server

- Previous
  - 1
    - Data from access database to a String Hmm I wouldn't understand why. You can also refer to it by index, what happens if you refer to it by index can you show the code you are using correctly and the names of the fields you have, exactly as they are (It may well be case sensitive) In addition - can we have the exact error message Tag: encrypting passwords in a database
  - 2
    - Setup and Deployment from Command Line The .net framework lets me compile a project using vbc.exe from the command line. I was wondering if there is a similar utility that can create an MSI from a setup and deployment project using a command line application. Can this be done Thanks! Tag: encrypting passwords in a database
  - 3
    - CliickOnce : Manifest may not be valid I just wanted to let you know that it happened to us on a couple of client computers just today. We solved it following your instructions. We distributed our app via ClickOnce for the last 8 months with no problem (like this) and this is the first new site install of the month. Is it something related to a recent Windows update I find it really hard, to say the least, to have to manually operate on the remote client machines to solve a problem no end-user would be able to approach. This is even more true when you consider we are using ClickOnce to enable distribution to a high number of clients with a nearly zero impact. Tag: encrypting passwords in a database
  - 4
    - Reading from Doc file onto a Reader Hi Vineed, I think the code example in Understanding the Word Object Model from a .NET Developer's Perspective has showed how you can do that, though a little complex. There's an article which shows how you can open a word file and grabs its contents in VB.net. Hope this can help you. Thanks! Tag: encrypting passwords in a database
  - 5
    - Write a program, which verifies that the procedure is properly written Write a procedure that takes an integer value and returns the number with its digit reversed. Write a program, which verifies that the procedure is properly written. Tag: encrypting passwords in a database
  - 6
    - VB Active X DLL fail on 64 bit while we use through VB script Thanks for your reply. However, because of the 32 bitness, it won't work in 64-bit windows 2003 OS then what is WOW for further I read in MS website that there is no 64-bit compiler available for VB. ( http://msdn2.microsoft.com/en-us/library/zwk9h2kb.aspx ) Also, when I create a vb executable, it creates the object without any error, but if I do from a vbs file or as in SQL 2005 SSIS an Active script, it fails to create the object. Any thoughts on how to use the vb6.0 activex dlls in SQL 2005 Integration services as an Active Script thanx Raj Tag: encrypting passwords in a database
  - 7
    - Setting Today's Date by Default in a Function >Any further suggestions Now that you're at the water, drink, drink!! ;-) Tag: encrypting passwords in a database
  - 8
    - DateTimePicker and language my regional settings are english. my .net framework is in french. my windows is in english. but my dateTimePicker is also in french Tag: encrypting passwords in a database
  - 9
    - Get Default Printer In vb.net i want to get the name of the default printer. I have found the following c# code but dont understand c#. Can anyone help me out translating this to vb Many thanks DllImport("winspool.drv", CharSet=CharSet.Auto, SetLastError=true)] public static extern bool GetDefaultPrinter(StringBuilder pszBuffer, ref int size); StringBuilder dp = new StringBuilder(256); int size = dp.Capacity; if (GetDefaultPrinter(dp, ref size)) { Console.WriteLine(String.Format("Printer: {0}, name length {1}", dp.ToString().Trim(), size)); } else { int rc = GetLastError(); Console.WriteLine(String.Format("Failed. Size: {0}, error: {1:X}", size, rc)); } Tag: encrypting passwords in a database
  - 10
    - baby lock And using the in-built stuff is normally much simpler than writing code to "reinvent the wheel" Windows Vista has much more parental controls than XP. So I'd hate to see you spend a lot of time writing something that is already implemented and probably would need modification to work on anything else. Tag: encrypting passwords in a database
  - 11
    - TwipsToPixelsY, TwipsToPixelsX equivalent in VB.NET Hi all, Could any one please tell what is the equivanet function of the TwipsToPixelsY, TwipsToPixelsX functions in VB.NET. These are supported by vb6 namespace if we use in .NET but i should not use VB6 in my project So please guide me what are the equivalents to these functions Regards, Tag: encrypting passwords in a database
  - 12
    - InnerCastExeption error. Hi! I wrote this code: Private Sub Form1_FormClosing(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles Me.FormClosing If txtUserName.Text = "Test" & txtPassword.Text = "Test" Then Me.Close() Else Form2.Show() MsgBox("Wrong username or password." & vbCrLf & "Protection Continued") End If End Sub And when i try to run it (debug) i get InnerCastExeption error. How can i fix this //Greetings, Zeelia Tag: encrypting passwords in a database
  - 13
    - How can I check the Internet connection speed via code? How can I check the connection speed by code. Tag: encrypting passwords in a database
  - 14
    - bitmap to Picturebox throught network I have a System.Drawing.Bitmap and I want to display it to another program's picturebox throught a network (localy or internet). How can I do it Tag: encrypting passwords in a database
  - 15
    - An attempt was made to access a socket in a way forbidden by its access permissions I have the same problem running on W2k3 server Tag: encrypting passwords in a database
  - 16
    - Sound Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load AxWindowsMediaPlayer1.Visible = False End Sub Tag: encrypting passwords in a database
- Next
  - 1
    - Print Preview Error You should be able to set the paper size manually using the PrintDialog control or programmatically using the PaperSize class. Tag: encrypting passwords in a database
  - 2
    - Textbox Focus From Form Load just to add, tried doing this in the form Shown event Tag: encrypting passwords in a database
  - 3
    - What Language represents &H100& Thanks for replying, I'm learning! Tag: encrypting passwords in a database
  - 4
    - newbie call errors Excellent, thanks! Tag: encrypting passwords in a database
  - 5
    - REading emails from exchange 2000 Hi, I have looked everywhere but no luck. I really need to be able to read messages and save attachments from an inbox. I have only managed to open up my own inbox which is no use. Dim oApp As Outlook.Application = New Outlook.Application() Dim oMsg As Outlook.MailItem Dim oAtt As Outlook.Attachment Dim oNS As Outlook.NameSpace = oApp.GetNamespace( "mapi" ) Dim i As Integer Dim x As Integer Dim oInbox As Outlook.MAPIFolder = oNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox) Dim oItems As Outlook.Items = oInbox.Items Dim count As Integer = oItems.Count Dim deletefile, savefile As Boolean oNS.Logon( "DevTest" , "password" , False , True ) I was hoping the ons.logon whould log me on to the "devTest" inbox but i guess the Dim oInbox As Outlook.MAPIFolder = oNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox) is opening up my own default inbox how can I open up the dev test inbox many thanks Tag: encrypting passwords in a database
  - 6
    - Create Users to Windows 2003 Programatically (vb) Hi all, I'm trying to add users remotely to a Windows 2003 Standard using the command net.exe, but I just can't make it work. This is my code: Dim p As New Process p.StartInfo.UseShellExecute = False p.StartInfo.RedirectStandardError = True p.StartInfo.RedirectStandardInput = True p.StartInfo.RedirectStandardOutput = True p.StartInfo.WindowStyle = ProcessWindowStyle.Hidden p.StartInfo.Arguments = " user " & xUser & " " & xPass & " /ADD /ACTIVE:YES /EXPIRES:NEVER" p.StartInfo.WorkingDirectory = "C:\windows\system32" p.StartInfo.FileName = "net" p.Start() Dim sr As IO.StreamReader = p.StandardOutput Dim sb As New System.Text.StringBuilder( "" ) Dim sinput As String = "" Do Until sinput = "-1" sb.Append(sr.ReadLine() & ControlChars.CrLf) sinput = sr.Read Loop p.WaitForExit() p.Close() Return sb.ToString it doesn't return anything, and user is not created. If I change the following line, it returns perfectly the table of users: p.StartInfo.Arguments = " users" so what could the problem be Thanks in advance. George Tag: encrypting passwords in a database
  - 7
    - how do i populate a checklistbox from a database in MSSQL server? I see you have some VB6 or lower background. Lots of old school techniques..... Great commenting.... Your loading the CLB from the one of the arrays XYG2, AWS, JBY after a click on the control. (I cann't find where you are loading the CLB at load.) I quickly scan the code so I could have missed it. If I just missed the load procedure then run your app and check the arrays to see if your convertion from data set to array is correct. When debuging does the arrays have data As I could not find the CLB in form load I don't know witch array or dataset your starting with... If thier isn't some thing I'm missing the CLB doesn't load data until some data in it is click so it will never show anything... Sorry for the quick scan if I did miss where your loading the CDL when the form opens or user does some thing then please post just it and i'll see if I can help more. Tag: encrypting passwords in a database
  - 8
    - Interface - Collection of Interfaces? I found the answer...... Code Snippet Interface IContact Inherits ISQL, IAddress Property FirstName() As String Property LastName() As String Property MiddleInitial() As String Property JobTitle() As String Property DefaultEmail() As Integer Property DefaultPhone() As Integer Property Emails() As GenericCollection( Of IEmail) Property Phones() As GenericCollection( Of IPhone) End Interface And then make sure you declare the Property as Friend or any other project only access Code Snippet Friend Property Emails() As GenericCollection( Of IEmail) Implements IContact.Emails Get Return _Emails End Get Set ( ByVal value As GenericCollection( Of IEmail)) _Emails = value End Set End Property *GenericCollection is a CollectionBase derived Collection (which also has an interface) I can now add Interfaces to a collection and pull them out, nearly effortless What are the potential limitations/problems of this I haven't run across anything yet, but would like to know what could possibly happen. As long as I can still use the interface down the road should I decide to change something! Am I getting Interface happy Tag: encrypting passwords in a database
  - 9
    - best practice when writing to sql server It depends - how often will you be accessing the Database If you are constantly accessing it, then there's little point in closing the connection after each write (that would be like going to the store, buying bread, going home; back to store, buy milk, go home; buy eggs, go to store, go home....). If it's every few minutes, then you may want to think about closing it (I'd keep the connection open but that's because of the nature of my applications that run 24-7). Some database managers get their knickers in a twist if you maintain a connection ad-infinitum, however. (I've only had connection/timeout issues with MS databases when I've held the connection open for more than several hours without doing anything with it - other databases seem to be a bit less tolerant). A good compromise will be to have your application have its own timeout, so that if no transactions have ocurred in a certain time period (e.g. 1 minute, 10 minutes, 1 hour, whatever is appropriate), disconnect nicely. This is easy to do if you encapsulate your database functionality. Then when a transaction is required, reconnect nicely. Which ever way you go - correct error handling will make your life much easier. Tag: encrypting passwords in a database
  - 10
    - Read Data from Card Reader Hi HenryHan, Sometimes if you have a drive mapped, say as the E:\ drive, and you attach a card reader or a USB flash stick it also maps to drive letter. So you end up with it looking like the reader hasn't attached. If you attach the card, give it time to connect and then go Control Panel->Admin Tools->Computer Management->Disk Management, you might see the card reader listed in there. You need to change the drive letter, right click on the drive listed on the bottom panel and select the change name menu option. These card reader generally are available as drives so reading and writing to them is like accessing files on a drive. There isn't any support for USB access in .NET, so you might need to look for third party controls, and if that is the case then I have no idea mate. Everything on USB that I've done has been just accessing the reader / flash stick as a drive. Tag: encrypting passwords in a database
  - 11
    - IP Address textbox The real easy way. Use the Masked Text Box control with this mask property ###.###.###.### and use the Validation event to confirm that the value entered is a valid IP address. Tag: encrypting passwords in a database
  - 12
    - Controls Transparency My purpose is to display rotated text or image on the running movie. For that I have used windows media player control in .net. I add the AxWindowsMediaPlayer (Windows Media player Control) on my form and set dock properties to fill. And put the Label and set the BackColor to Transparent. But instead of displaying the movie as background its displays the BackColor of the form. I want the background movie run in background and display the rotated text amd image on that without background color of the text and image. Thanks in advance. Tag: encrypting passwords in a database
  - 13
    - metadata help does anyone know how i would go about editing metadata of a video like changing the artist Tag: encrypting passwords in a database
  - 14
    - How do you add a pause with the Timer control? How about using two timers? Sorry, that doesn't help. I need something as simple as the code I posted above. It needs to be placed in the button click event, and it will be repeated dozens of times for split seconds each time as the textbox keeps refreshing. Other pauses with varying times (fractions of a second) will also be used in the same event to separate each of 8 textboxes, (which I set up as an array of textboxes in a separate sub). As you can see, every statement using System.Threading.Thread.Sleep should be replaced with a pause using a Timer instruction, but as simply and clearly as possible! Here is part of the actual code I'm using now. It works perfectly except that the user cannot interrupt the process to select another event. Private Sub btnNext_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNext.Click Dim winner, L, idig, Q, R As Integer Dim swin, dig As String ' ' ' Note: Some code omited here -- Some variables were declared at class-level winner = shuffle(win) swin = winner.ToString L = N - swin.Length swin = StrDup(L, "0" ) & swin win = win + 1 If flash = False Then 'show winning number instantly ' ' ' Code omitted since it doesn't use a pause Else If win = 1 Then lblWait.Text = "Always wait for flash to stop before clicking Next or another button." lblWait.Refresh() System.Threading.Thread.Sleep(100) End If For x As Integer = 1 To 8 'clear previous winning number TextArray(x).Clear() TextArray(x).Refresh() Next x System.Threading.Thread.Sleep(200) 'pause before next number lblIndex.ForeColor = Color.FromArgb(130, 130, 130) lblIndex.Text = win.ToString 'winner count in gray lblIndex.Refresh() Q = N If P > 0 Then 'don't flip inactive digits For x As Integer = N To N - P Step -1 dig = swin.Substring((N - x), 1) TextArray(x).ForeColor = Color.FromArgb(120, 120, 120) TextArray(x).Text = dig TextArray(x).Refresh() System.Threading.Thread.Sleep(200) Q = N - P 'active digits Next x End If For x As Integer = Q To 1 Step -1 'flip winning number digits dig = swin.Substring(N - x, 1) idig = Convert.ToInt32(dig) For y As Integer = 0 To 9 'first flip from 0 to 9 TextArray(x).ForeColor = Color.Black TextArray(x).Text = y.ToString TextArray(x).Refresh() System.Threading.Thread.Sleep(90) Next For y As Integer = 0 To idig 'then flip from 0 to value TextArray(x).Text = y.ToString TextArray(x).Refresh() System.Threading.Thread.Sleep(90) Next y System.Threading.Thread.Sleep(90) Next x lblIndex.ForeColor = Color.Black 'winner count in black after flip finishes lblIndex.Refresh() For y As Integer = 1 To 7 'flash winning number in gold If y Mod 2 = 0 Then R = N Else R = Q For x As Integer = 1 To R 'alternate active with all digits TextArray(x).BackColor = Color.Gold Next x For x As Integer = 1 To N TextArray(x).Refresh() Next x System.Threading.Thread.Sleep(200) For x As Integer = 1 To N 'original color TextArray(x).BackColor = Color.FromArgb(255, 255, 192) Next x For x As Integer = 1 To N TextArray(x).Refresh() Next x System.Threading.Thread.Sleep(90) Next y lblWait.Text = "" End If End Sub Tag: encrypting passwords in a database
  - 15
    - Answer command prompt programmatically I am trying to answer a prompt in the command prompt window programmatically so the user does not see the prompt nor have to interact with it. I have tried ECHO, but it does not put the text after the prompt. Also, how do you add the text and continue -- that is, simulate pressing the ENTER key I am totally new to this, so any ideas will help. Thanks! Sample: ECHO [text to send] Tag: encrypting passwords in a database
  - 16
    - creating file name with date I'm using excel 2003 with VB 6.3 I am writing a macro to move some data around and do some subtotalling; I would the macro to save the file as nameispecify with the current date lpantos02012007.xls without me specifiying the date is there a way to do this Thanks! Tag: encrypting passwords in a database

steve1_rm

Hello,

I am creating an application using vb windows applcation and using SQL 2005.

I have a table of users, that contain there usernames and passwords. When a new user is added it stores all the passwords in clear text in the database.

What is the best method to use to be able to crypt the passwords in the database.

Also, when the user login, i have a sql statement that will compare the username and password that they enter in the login dialog box, to what is in the database. If the password is encryted, would I still be able to compare their password to see if they can still login.

i.e.


"Select * From Users Where LoginID=@LoginID And Password=@Password"

Many thanks for any suggestions,

Steve

Top

Re: encrypting passwords in a database

TaDa

The best practice is not to store the password itself, but a hashcode of the password, this is basically a "one way" encryption, meaning you can't retrieve the password from the hashcode, but the same password will always produce the same hashcode. The string class's GetHashCode method should suffice.

Top