Thanks Ben,

Found the problem! We were testing for valid connection using the SqlConnection object. It was removing the password from the connection string. Thanks for all the help.

So, was the problem in the framework? (is there anything I need to add a bug report for?) or was it in your code?



I'm glad you found the problem

Looks like the SqlDataClient clears the password once the connection was opened. We were passing the connection object we gathered from the DataLayer.DataSources to a function that verified the connection using the SqlDataClient.SqlConnection open method. Everything was correct going into the function but once the connection was opened the connection string was getting modified. The password was removed. I don't know if this is by design for security reasons or what. In any case we passed in a string in to test for a valid connection instead of the actual connection object so it wouldn't get changed.

That works...



If you ever need to get a new connection object from the DataLayer.DataSources, you can call DataLayer.DataSources("").CreateBlankDbConnection() which will return a DbConnection object for that data source.