title: How to get rid of the error: "Data source name not found and no default driver specified" in .net?
body: <p>I was trying to built a asp.net web app with the connection string defined in the webconfig file. When I try to debug I am getting the following exception:</p>
  
  <blockquote>
    <p>ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified</p>
  </blockquote>
  
  <p>The connection string looks like this:</p>
  
  <blockquote>
    <p>connectionString="Driver={MySQL ODBC 5.1 Driver};server=XX.XX.XX.XX;port=3306;database=db_name;user=username;pwd=pass;option=3;" providerName="System.Data.Odbc"/></p>
  </blockquote>
  
  <p>The driver is installed and I can see it listed in the 'ODBC Data Source Administrator'.</p>
  
  <p>I tried changing the build configuration to 'Any CPU', still it failed.</p>
  
  <p>Can somebody help me out to figure whats going on here??</p>
  
  <p>Thanks,</p>
  
  <p>Uday</p>