Developer

the error is Table 'khemkas_social.FARMERS' doesn't exist. I added the table using phpmyadmin in heliohost. but why cant my C# applicaton find it

Hey, I tried your solution. now i get this : Access denied for user 'khemkas_root'@'nusnet-213-192.dynip.nus.edu.sg' (using password: YES)". Why does it add things after @. I never added them. below is the code private void Initialize() { server = "stevie.heliohost.org"; database = "khemkas_social"; userName = "khemkas_root"; password = "something"; string connectionString; connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + userName + ";" + "PASSWORD=" + password + ";"; connection = new MySqlConnection(connectionString); } thanks

Below is the code I am using to connect : private void Initialize() { server = "http://thefarmersmarketplace.heliohost.org"; database = "khemkas_social"; userName = "Something"; //changed for security reasons. password = "something"; string connectionString; connectionString = "SERVER=" + server + ";" + "DATABASE=" + database + ";" + "UID=" + userName + ";" + "PASSWORD=" + password + ";"; connection = new MySqlConnection(connectionString); } However, I am not able to connect to the database. What should the server be. I am doing anything wrong