#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    2
    Rep Power
    0

    Unhappy Table doenst exist in a remote database


    Hi

    Is there anyone who experience about this error

    Error: ERROR [42S02][MySQL][ODBC 5.2(w) Driver][mysqld-5.1.58]Table 'db_attendance.tblUser' doesnt exist


    I have a remote Mysql Database server installed in LINUX CENTOS
    then one of my programmer make new program with Mysql Database
    we run it the application in windows 7 and we have also a Mysql ODBC version 5.2w

    when we tried to login theres a popup message about table doesnt exist but if we look at in the phpmyadmin the database was created and also the table are existed.




    Thanks
  2. #2
  3. Known to taste like chicken
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    In front of my computer
    Posts
    399
    Rep Power
    312
    a bit of a guess, but check the permissions on the DB user that is trying to access the table. Make sure it has the correct permissions for that table otherwise the user wont be able to 'see' that the table exists.
    "Take thy beak from out my heart, and take thy form from off my door" - Homer J Simpson / Edgar Allan Poe

    Looking for a project Idea?
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2013
    Posts
    2
    Rep Power
    0
    Originally Posted by sir_drinxalot
    a bit of a guess, but check the permissions on the DB user that is trying to access the table. Make sure it has the correct permissions for that table otherwise the user wont be able to 'see' that the table exists.
    Hi sir_drinxalot

    thanks for your response

    but i use root account that has a privileges to access all database and table.


    thanks
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Mar 2006
    Posts
    2,484
    Rep Power
    1752
    Check the case of the table name on the Centos server - *nix mySQL is case-sensitive, Windows-based mySQL isn't.
    The moon on the one hand, the dawn on the other:
    The moon is my sister, the dawn is my brother.
    The moon on my left and the dawn on my right.
    My brother, good morning: my sister, good night.
    -- Hilaire Belloc

IMN logo majestic logo threadwatch logo seochat tools logo