New Server (Brinkster) doesn't support DSN connection

[bkorg]

Hello

I must migrate my website.

In the old server I had on web.config file the following connection:

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

Now, my new server (brinkster), does not support DSN connection.
Can someone tell me how can i make the connection?

Thanks
MBento

[PsychoCoder]

You should be able to change your connection string to look like this (just remove the DSN part)

<add name="ConnectionString" connectionString="SERVER=localhost;DATABASE=YourDBName;UID=sqladmin;PWD=sql1024"
   providerName="System.Data.Odbc" />