Connect to SQL Server db in a secured way
we have few vb apps running that connects sql server db. we have hard coded
the usernames & passwords. In this case all the programmers knows the
usernames & passwords. They can harm databases. We want to take that things
out of the apps. So the question is how to connect to sql server db in such
a way that programmer should not know the usernames & passwords.
We can create System DSN but it requies username & password along with
DSN name. Any suggestions guys.