ConnectionString without DSN not working

Dec 20, 2012
Reaction score
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

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

And here is the one without using DSN

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

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

Server Error in '/' Application.

Runtime Error

Any ideas?

Thanks in advance.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question