1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MyODBC driver problem

Discussion in 'Plesk for Windows - 8.x and Older' started by jovana, Feb 5, 2007.

  1. jovana

    jovana Regular Pleskian

    25
    57%
    Joined:
    May 31, 2006
    Messages:
    114
    Likes Received:
    0
    Location:
    Haarlem
    Okay, I had a problem with MySQL 5 query's in combination using Plesk 8.1 and MySQL 5. I want to share the solution with you, and maby SWsoft can als fix this problem in the next release.

    The Problem:
    A normal simple query like:
    select * from table; does not work.

    The workaround:
    Modify your query to:
    select id, name, date from table; does work well.

    The solution:
    After a search on the mysql bug report site, I found this is a known problem.

    In the Plesk 8.1 installation package there is the MySQL 3.51.11 driver shipped. This is a wrong driver in combination of MySQL 5. To have this problem fixed download (http://dev.mysql.com/downloads/connector/odbc/3.51.html) the latest one, 3.51.12 driver. Al problem are gone.
     
  2. sergius

    sergius Golden Pleskian

    28
    57%
    Joined:
    Nov 6, 2005
    Messages:
    1,898
    Likes Received:
    0
    jovana, thank you for your report. We will update MySQL ODBC in Plesk distribution in the next major version.
     
Loading...