Warning: Invalid memo field conversion(s) starting at record "number" (Error 1486)

  • Article

A memo conversion error was reported while fetching large data in record number of the remote result set.

  • The ODBC driver cannot convert some large remote data values into the local view data type.

    Use a conversion function in the remote SQL statement to convert the data to a different data type before being fetched; use the DataType view field property to change the local data type. Use server-specific settings to limit the amount of data sent for each large data value.