Database UserID and Password visible 1

[DavidLogue]

Hi,
I use dsn-less connections in my VB code to connect to SQL Server. Using

With AdoCon
.ConnectionString = ConStr
.Open
End With

But if I look at the compiled code through notepad then the connection string including the username and password are visible.
Any ideas on how to hide this??

 

[tb]

Encrypt the Username and Password and store it in the registry and and runtime read and de-crypt the username and password in 2 seperate variables.

 

[DavidLogue]

Simple but brilliant...thanks...