How to give access to Cornerstone

Owned by Joss Herrmann
Last updated: Apr 02, 2024
3 min read

Installation:

  1. Go to the Datasources page and add a new “GTruck” connector

image-20240319-111328.png

 

  1. Enter the name of the Datasource

image-20240319-193204.png

  1. Press “Configure”

  1. Select “Cornerstone” from the list of Templates than click “Save”

  1. The now appearing options should fit almost all Cornerstone setups but can also get changed if needed.
    Then press the “Download” button

  1. Click the link to download the tray version of the Slyncy Agent

  1. Install the Tray version of the Slyncy Agent on the server running the Cornerstone database.
    Please note: If you do not have access to Profit Diagnostix please contact us at support@profitdiagnostix.com so we can send you the download link.
    After installing check the Windows tray if the Slyncy Agent is running

  1. Make sure that you configure the Slyncy Agent to automatically start after booting windows (Autostart) in case the Server has to be restarted.

 

Troubleshooting:

In some cases (e.g. server updates) the Profit Diagnostix datasource log shows the error like :

"STATUS: Invalid ODBC handle"

This issue is related to changes in the Windows 64 bit vs 32 bit architecture.

To fix this the appropriate DLL files have to be copied into the Slyncy programm folder to replace the old DLL files. The DLL files can be downloaded here:

  • Stop the Slyncy Agent

  • Locate the program folder of the Slyncy Agent that contains the DLL files (e.g. “dbjdbc16.dll”).
    This is usually “C:\Users\<user>\AppData\Local\Programs\slyncy” or "c:/program files/slyncy/libs".

  • Extract the files from the ZIP archive and copy/replace them with the files in the program folder

  • Restart the Slyncy Agent