Problem with connection strings being saved in the XSD files.

[CodeMonkey]

We have quite a few datasets that have been designed through the IDE. In
our application, we generate a connection string to the server based on
what the user configures the application for. The problem is, our
connection strings on the development machines are being saved into the
XSD files. While this isn't a huge issue, it's storing the password in
it as well. I have tried to make sure every dev's machine has the "Save
Password" option turned off, I also told it NOT to store the connection
string in the app.config, which it is not doing anymore...

How can I stop the studio from storing the connection string in the XSD
files? At least telling to stop storing the password would be acceptable
to me.

Visual Studio .Net 2005/Vb.Net

[RobinS]

What kind of database are you using? If using SQLServer, why not use
Windows authentication?

Having passwords anywhere in a file is a really bad idea. I'll be
interested to see if anybody provides a solution for you.

Robin S.
-----------------------
"CodeMonkey" <sp******@suck.comwrote in message
news:pb*****************@newssvr17.news.prodigy.ne t...

We have quite a few datasets that have been designed through the IDE. In
our application, we generate a connection string to the server based on
what the user configures the application for. The problem is, our
connection strings on the development machines are being saved into the
XSD files. While this isn't a huge issue, it's storing the password in it
as well. I have tried to make sure every dev's machine has the "Save
Password" option turned off, I also told it NOT to store the connection
string in the app.config, which it is not doing anymore...

How can I stop the studio from storing the connection string in the XSD
files? At least telling to stop storing the password would be acceptable
to me.

Visual Studio .Net 2005/Vb.Net