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
Salesforce ODBC Issue -old issue in forums
Re: Salesforce ODBC Issue -old issue in forums
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.
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.
-
- Posts: 2
- Joined: Wed 04 May 2022 18:15
Re: Salesforce ODBC Issue -old issue in forums
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.
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.