Regarding Passwords

[Sujatha]

Hi,
I'm using Visual Basic 6.0(SP3) with Sql Server 7.0. I'm having a table similar to Master Database's Sysxlogins Table where i'm storing the same username and password from Master's Sysxlogins Table. In Visual Basic, when the user enters the username in a text box i want to
retrieve the password from that table and store it in a string variable. Here note that the user is not entering the password. The password in table is stored in varbinary datatype. If i retreived the password from table and assigned it to a variable it returns value ike "?]???????". I want the exact password string here for example if the password is "rahul" then i want "rahul" in the string variable. Is it possible?


Sujatha

[Dim]

I'm not a db person, but...You say that the pass is stored someplace and the user doesn't enter it...can you extract that password somehow? If so..then string it like that.

'This is how you would take the pass out of a text file...i assume you need something similar.
Private Sub Form_Load()
Open "test.txt" For Input As #1
    Text1.Text = Input$(LOF(1), 1)
Close #1
Dim pass As String
    pass = Text1.Text
    MsgBox pass
End Sub

Gl,
D!m