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:

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

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.

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