#1898 - Cannot validate to connet
SugarCRM version: 6.5.11 Opacus Activities Sync version: 2.0.6
We just got the trial of the new version to see if it would work but we cannot connect. We use SQL not MySQL for our SugarCRM.
The old version worked with some issues (see Note below) but we cannot get this new version to connect. The error we get on the calendarobjets query **is:
**UTC_TIMESTAMP' is not a recognized built-in function name. We think this is because UTC_TIMESTAMP doesn't exist in MSSQL. Only MySQL.
Do you have a version that works for MSSQL? This was not an issue in the old version.
NOTE: We previously had Activities Sync version 1.5.9 and we used CalDav with JB workaround to sync on Android phones. The application would sync from crm to phone without issue as well as sync changes made to an event on the phone with the crm. It would not sync from phone to CRM for any appointments created on the phone.