3.51.17 error 1064 - can't get field metadata due to syntax error in SQL query

mysql-connector-odbc-3.51.17r581/driver/catalog.c

/* Build a SELECT ... LIMIT 0 to get the field metadata. */

    if (!(select= (char *)my_malloc(sizeof(char) * (ulong)result->row_count *

                                    (NAME_LEN + 1) + NAME_LEN * 2,
                                    MYF(0))))

    {

      set_mem_error(mysql);
      return NULL;

    to= strxmov(select, "SELECT `", NullS);     while ((row= mysql_fetch_row(result)))
{

      lengths= mysql_fetch_lengths(result);
      to+= mysql_real_escape_string(mysql, to, row[0], lengths[0]);
      to= strmov(to, "`,");

    to= strmov(to, " FROM `");
    if (cbCatalog)
{

      to+= mysql_real_escape_string(mysql, to, (char *)szCatalog, cbCatalog);
      to= strmov(to, "`.`");

    to+= mysql_real_escape_string(mysql, to, (char *)szTable, cbTable);     to= strmov(to, "` LIMIT 0");

I think line 772 must be

strmov(to, "`,`"); Received on Thu Jul 19 04:45:08 2007

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek