MySQL Forums
Forum List  »  Connector/ODBC

Error "SUM does not exist"
Posted by: Oliver Pike
Date: October 22, 2010 11:51AM

I'm getting the following error in a third party query tool that goes through a Connector ODBC connection:

"FUNCTION mydb.SUM does not exist. Check the 'Function Name Parsing and
Resolution' section in the Reference Manual"

I'm able to successfully run the same query (with the sum() function) through phpmyadmin which uses a different client driver (mysqlnd php native driver).

The error message appears to be coming from the database (or the driver) and not
the third party query tool. The only explanation I can come up with right now is that the sum() function is not being supported by the odbc driver, but I haven't
found any other instances online of people complaning about that limitation.

Options: ReplyQuote


Subject
Written By
Posted
Error "SUM does not exist"
October 22, 2010 11:51AM
October 22, 2010 01:14PM
October 22, 2010 02:18PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.