build up the connectionstring?

[Richard.Ainsley]

I have exactly the same issue. I can build up the connection without the user naame and password. But as soon as I add the password VB mangles the string somehow not only hiding the password, but also rendering the connection string useless. If nybody knows how to access the connection wizard for SQL server 2005 programatically,so I can build a connection string at run time -- please help. Note aso if I supply the identical string in a string constant VB is quit happy to use that. But, since I have many potential databases which depend on user roles, using clear text that is visible in the executable is not only risky, it is not workable either. How about some assistance MS engineers. This is the 4th posting for this issue!

 

[JohnH]

SqlConnectionStringBuilder Class is probably what you need.