HANA DB ODBC Driver and LDC

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?

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

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

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