ODBC Conncetion to MySQL 5.1
<p>I have a database built by a commercial company.  Their reporting is basically non-existent.  They have a few canned reports but not what we need.  Of course, they highly recommend not connecting to the database and can build custom reports for a "small fee".  </p>

<p>My thoughts were to connect to the database using linked tables, then use something like Business Objects, Access, or even Excel to build all the reports I want for a "small fee".  The only means I know to do this requires an ODBC connection.  I have downloaded / installed the MySQL 5.1 Driver.  But, I am having issues connecting.</p>

<p>I have a user name and password for the server.  When I try the test connection I get </p>

<blockquote>
  <p>Connection Failed: [HY000][MySQL][ODBC 5.1 Driver]Access denied for
  the user 'userrname'@ '....'(using password: YES).</p>
</blockquote>

<p>Tried establishing a read only account as well without a password and received the same error message but at the end it says</p>

<blockquote>
  <p>(using password: NO)</p>
</blockquote>

<p>Any suggestions as to what is causing this?  Any workaround?</p>