Why is the Connection String not correctly displayed with a OleDB Connection on a SQL database with a SQL Server Native Client 10.0?
The Connection to the SQL server and to the database was correctly created. The connections string looks like this:

When the connection with this connection string is checked with Test, the note appears:

Several redundant parameters are in the connection string. These can be deleted. These are all the parameters that contain empty fields "". Besides the parameter Password is missing for password in the connection string. Add this retroactively. For the connection to work smoothly, the connection string must look like this.

You can find more information about creating Connection Strings at http://www.connectionstrings.com/.