TASKCENTRE

None Defined

SAP Business One Connector - Connection Configuration - Error Running SQL

When testing a connection the following error is returned `Error Running SQL`

Solution: The fix for this applies to how field names are handled in the query that builds the connection. It now uses fully qualified names so that this: COLUMNS.COLUMN_NAME becomes INFORMATION_SCHEMA. COLUMNS.COLUMN_NAME.

Attached are updated files for the Tools. They need to go in c:\inetpub\wwwroot\CommunicatorWS\bin.

Alternative Solution (windows 2012R2): Copy the DLL from the second attachment in to c:\inetpub\wwwroot\CommunicatorWS\bin, replacing the one that is there.

Solution

23 Jun 2014