ConnectionString without DSN not working

[bkorg]

HELLO!
I have been using MYSqlConnection .NET strings in my web,config and my
application is working fin. However due to requirements, I am forced
to change the connection string to not use DSN and I cannot connect to the
data. Can anyone point out what is wrong with my settings.

Here is the MYSqlConnection in my web.config

<connectionStrings>
<add name="ConnectionString" connectionString="Dsn=ecm_sql;SERVER=***;UID=***;PWD=***"
providerName="System.Data.Odbc" />
</connectionStrings>


And here is the one without using DSN

<connectionStrings>
<add name="ConnectionString" connectionString="server=***;uid=ecm2;pwd=***;database=***"providerName="System.Data.SqlClient" />
</connectionStrings>

When I try to open the Asp.net application Configuration pages, I get
the following error messages:

Server Error in '/' Application.

Runtime Error

Any ideas?

Thanks in advance.