Posted Wed, 01 Jun 2022 15:36:04 GMT by Ryan Potter IT
About 3 months ago, after installing a minor version update of Docuware's Local Data Connector, we were no longer able to connect to the Database using ODBC. Rolling back the installed version fixes the issue but I don't think we can continue not upgrading the software as we are using Docuware Cloud and I believe it eventually forces an upgrade.

Does anyone have any recommendations as to why this is occuring or what we might be able to do to fix this issue?
Posted Thu, 09 Jun 2022 00:01:27 GMT by Matthias Wieland Senior Director Support EMEA
Dear Ryan Potter! It looks like the Community cannot answer your question. That's why we have opened a Support Request with the Number SR-178359-P5Q2W for you. A Software Support Specialist will contact you directly to follow up. We will update this thread with the solution as soon as we have resolved the Support Request. With best regards, DocuWare Support Team
Posted Fri, 17 Jun 2022 11:35:18 GMT by Tomas Pavelka Consultant
Hi Ryan!<br> <br> Not sure if you already have the answer but we have encountered the same issue.<br> Thankfully DocuWare responded with this:<br> <br> In the installation directory of the Local Data Connector there is the file: C:\Program Files (x86)\DocuWare\Local Data Connector\DocuWare.DAL.dll.config.<br> This configuration file is overwritten each time the Local Data Connector is updated. The adjustments to this file must therefore be reactivated after each update.<br> To work around the SAP HANA DB syntax error, remove the comment tagging of the following lines:<br> &lt;!--&lt;Parameters&gt;<br> &lt;System.String DictionaryEntryKey="LIMIT"&gt;IGNORE&lt;/System.String&gt;<br> &lt;/Parameters&gt;--&gt;<br> Enabling this option, prevents the TOP or LIMIT parameter from being added to the statement.<br> However, this means that the query will thus access the database without restriction.<br> The resulting statement would be: SELECT DISTINCT "column" FROM ...<br> <br> Please let me know if this was helpful. It definitely helpd us with viewing SAP HANA views in DocuWare.<br> <br> Best regards<br> Tomas
Posted Fri, 17 Jun 2022 11:39:27 GMT by Tomas Pavelka Consultant
Also just to let you know - I am not sure if the config file will be overwritten after the next update but if so, you should be able to create a script/minor .NET app to automate the "un-commenting" process.

Tomas

You must be signed in to post in this forum.