Error "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'log10' in expression" when connected to a text file (.csv) (4308037)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "[Microsoft][ODBC Microsoft Access Driver] Undefined function 'log10' in expression" when connected to a text file (.csv)
Description

The following error occurs when the numerical function LOG10(x) is included in query:
"[Microsoft][ODBC Microsoft Access Driver] Undefined function 'log10' in expression"
LOG(x) works as expected.
Cause

Toad uses Microsoft ODBC Text driver. LOG10 is not supported by this driver.
Resolution

RESOLUTION 1:
Use the numerical equivalent "Log10(a) = Log(a) / Log(10) "
or
RESOLUTION 2:
Import the text file to local storage and query from there. Then any function that mySQL supports (including LOG10() can be used.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title