Mysql Error ERROR [42S22] [MySQL] RRS feed

  • Question

  • User-455838016 posted

    Hi all

    I have a program reading exactly the same table in the same database on my local system made in ASP.net 2.0 with MYSQL 5.0 but when i deploy this project on IIS Server using exactly the same code and database and tables(now using MySQL 4.0 on Server),It executes and when i press button to activate Dropdownlist  it declare

    ERROR [42S22] [MySQL][ODBC 3.51 Driver][mysqld-4.0.13-nt]Unknown column 'id' in 'field list'

    I cannot figure out what is happening....... I copied and paste the code from the working program into the non working program to no avail,same error condition repeats.....please help me get rid of this error.

    Please help



    Tuesday, June 7, 2011 4:11 AM


  • User-1694870838 posted


    Thank you for your post.

    Your depoly your project on IIS Server using a low version MySQL 4.0, It have not upward compatibility,so you can deploy your project using MySQL 5.0.

    Bset Regards,


    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, June 9, 2011 2:29 AM