Salesforce ODBC Issue -old issue in forums

[quantumbuc]

Hi. In searching the forum, I see this problem existed years ago, but I didn't see a solution.
I have just started using the odbc drivers (with MS Access). Straight queries are fine. But if I join two tables (such as the Case object and the User object), I get an ODBC--call failed error.
It says: [Devart][ODBC]String data, right-truncated (#1781280653)

Thanks in advance.

-Elliott

[MaximG]

Hi Elliott,
Thank you for your request.

For us to find out the reasons for this error, please provide the full text of the SQL query, the execution of which leads to the described error.

[quantumbuc]

Thank you for the response. As mentioned, I'm using MS Access. In SQL View, one example query is:

SELECT Case.CaseNumber, User.Username
FROM [Case] INNER JOIN [User] ON Case.OwnerId = User.Id;

This is just one sample. Any joining of tables causes this error.