title: Website can't connect to database on smarterasp.net webserver - possible error in connection string
body: <p>I am getting a problem when I try to connect from my website to my database on my webserver (smarterasp.net). Everything works fine on the local host, then I uploaded the site to smarterasp.net and created the database there, now the site can't connect to the database, here is what I have in my web.config:</p>
  
  <pre><code>&lt;?xml version="1.0"?&gt;
  &lt;configuration&gt;
  
  &lt;connectionStrings&gt;
      &lt;add name="UsersConnectionString1" connectionString="Data Source=MYSQL5012.Smarterasp.net;Initial Catalog=db_9df63f_active;Uid=9df63f_active;Pwd=MYPASSWORD; "
      providerName="System.Data.SqlClient" /&gt;
  &lt;/connectionStrings&gt;
  &lt;system.web&gt;
    &lt;compilation targetFramework="4.5" /&gt;
    &lt;httpRuntime targetFramework="4.5" /&gt;
  &lt;/system.web&gt;    
  &lt;appSettings&gt;
   &lt;add key="ValidationSettings:UnobtrusiveValidationMode" value="None" /&gt; 
  &lt;/appSettings&gt;
  &lt;/configuration&gt;
  </code></pre>
  
  <p>Where password obviously includes my real password.</p>
  
  <p>Here is what smarterasp.net provided as the connection string:</p>
  
  <p>ASP.net "Server=MYSQL5012.Smarterasp.net;Database=db_9df63f_active;Uid=9df63f_active;Pwd=YOUR_DB_PASSWORD;"</p>
  
  <p>Classic ASP "Driver={MySQL ODBC 5.1 Driver};Server=MYSQL5012.Smarterasp.net;Database=db_9df63f_active;Uid=9df63f_active;Password=YOUR_DB_PASSWORD;"</p>
  
  <p>I also tried putting the connection string in the web.config file as connectionString= "Server=MYSQL5012.Smarterasp.net; Database=db_9df63f_active; Uid=9df63f_active; Pwd=MYPASSWORD;"</p>
  
  <p>but this didn't work either.</p>
  
  <p>Appreciate any help. Thanks!</p>