Salesforce ODBC Issue -old issue in forums

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
quantumbuc
Posts: 2
Joined: Wed 04 May 2022 18:15

Salesforce ODBC Issue -old issue in forums

Post by quantumbuc » Wed 04 May 2022 18:19

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
Devart Team
Posts: 1811
Joined: Mon 06 Jul 2015 11:34

Re: Salesforce ODBC Issue -old issue in forums

Post by MaximG » Fri 06 May 2022 11:10

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
Posts: 2
Joined: Wed 04 May 2022 18:15

Re: Salesforce ODBC Issue -old issue in forums

Post by quantumbuc » Tue 10 May 2022 13:09

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.

Post Reply