SQL Connection on SQL Server Database

Why is the connection string not created correctly for an OLEDB connection to a SQL database with a SQL Server Native Client 10.0?

 

The connection to the SQL Server and the database was created correctly. The connection string is:

faq5

 

If the connection with this connection string is terminated with Test the note appears:

faq6

 

There are several redundant parameters in the connection string. These can be deleted out. These are all parameters that contain empty fields ". In addition, the connection string is missing the parameter Password for the password. Add this afterwards. The connection string must look like this for the connection to work smoothly.

faq7

 

icon_cross-reference

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