-
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
-
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.
Code:
'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
