Connection error with Godaddy mysql RSS

• • Reply
  

  gibijohn

  Member

  2 Points

  12 Posts

  Connection error with Godaddy mysql

  Jan 28, 2013 08:11 PM|LINK

  I am facing  the following error when i try use the table.but the table exists

  ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.0.96-log]Table 'db.tablename' doesn't exist

   I am using the following connection string for the connection with MYsql and using mysql with godaddy
  

  connectionString="DRIVER={MySQL ODBC 3.51 Driver}; SERVER=XXXXX.db.7088448.hostedresource.com; PORT=3306;DATABASE=XXX; USER=XXXXX; PASSWORD=XXXXX; OPTION=3;

  
  

  Anybody please suggest a solution for the same
  

  Thank You

  Gibi
  

  • Moved by Mikesdotnetting on Jan 29, 2013 04:55 AM
• • Reply
  

  ignatandrei

  All-Star

  134491 Points

  21566 Posts

  Moderator

  MVP

  Re: Connection error with Godaddy mysql

  Jan 28, 2013 08:28 PM|LINK

  gibijohn

  ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.0.96-log]Table 'db.tablename' doesn't exist

  Please share full stack code and error.

  My .NET blog : http://msprogrammer.serviciipeweb.ro/ |2012 Programmer tools
• • Reply
  

  gibijohn

  Member

  2 Points

  12 Posts

  Re: Connection error with Godaddy mysql

  Jan 28, 2013 08:51 PM|LINK

  Thanks for the  reply.I got the solution. In godaddy my sql ,table names are case sensitive that is the reason for the earlier error

  Thanks Again

  Gibi

  • Edited by gibijohn on Jan 28, 2013 08:52 PM
  • Marked as answer by Angie xu - MSFT on Feb 04, 2013 01:33 AM