Dear Avinash,
Thanks for your code.
But I think that I haven't explained my need correctly.
It is like this ----
Users will go to login form(of course, it will be .exe).
User will type MySQL login ID and password and computer name hosting
MySQL.

Login ID & password will be different for each & every user.
If the ID & password are correct, then permission is granted and Main
Form opens.
Otherwise permission is denied.

Therefore, I can't hardcode connection string in app.config as you
say.

You code reads (in app.config) ---

<connectionStrings>
>           <add name="DefaultConnectionStringToMasterDatabase"
> connectionString="Data Source=ServerName;Initial Catalog=Master;integrated
> security=True;uid=UserName;pwd=Password"
>             providerName="System.Data.SqlClient" />
>     </connectionStrings>


Here, we can't hardcode like  "Data Source=Wheels;uid=Vineet;pwd=qwert
$1"

In this situation, what's your call?

---Vineet.

Reply via email to