Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025

 


Article

Executing a query in Microsoft Access with a linked table against Salesforce with the ODBC Salesforce driver returns the error "Reserved error (-7711); there is no message for this error"

« Go Back

Information

 
Article Number000033930
EnvironmentProduct: Connect XE for ODBC Salesforce driver
Version: All supported versions
OS: Windows x86 and x64
Database: Salesforce
Application: Microsoft Access
Question/Problem Description
Executing a query in Microsoft Access with a linked table against Salesforce with the ODBC Salesforce driver returns the mentioned error.
Steps to Reproduce
Clarifying Information
Error MessageReserved error (-7711); there is no message for this error
Defect/Enhancement Number
Cause
Resolution
Add WorkArounds=33554432 string to the data source in the registry using the registry editor or in the connection option "Extended Options" located under the Advanced tab of the data source.

Enabling this option prevents Microsoft Access from failing when SQLError / SQLGetDiagRec returns an extremely long error message.
 
Workaround
Notes
References to other documentation:
Progress Article(s):

000004300, "Finding and setting workarounds - workarounds2 Connect for ODBC connection options"
Attachment 
Last Modified Date5/1/2018 1:25 AM