Page Comparison

1. Create a gtruck connector in the users interface : Settings >> datasources >> gtruck. Call it something like XXXvets Reckon
2. Download the Windows TRAY gtruck to the desired workstation
3. Ensure you have access to the Admin username and password for the Reckon file
4. Install QODBC from here: from here: https://www.flextools.com/qodbc . You may be able to get a 30 day trial to make sure it works, but after 30 days you have to buy a license from the same site.
   in the old days we also kept a copy here, but this could be out of date and is no onger free to use - http://assets.slyncy.com/install/qodbc1.exe
5. go to  file >> utilities >> configure odbc again after running and you will see a different screen this time (or just go on the start menu and search qodbc >> select the qodbc setup program) . Note the data source name is what will be required in the connection screen in reports-admin
   
   
   
   
   
6. Note that the above window you should set the 'Locate Company File' to the right file, otherwise the data will only sync if reckon is open. It does not however let you set this at this point, so will mention it later.
   
    
7. You can optionally validate if the data source has been installed by going to: C:\Windows\SysWOW64 and executing odbccad32.dll. Here you will see the same  data source under system DSN
   
    
8. Open Reckon and login 
9. In Reports Admin, click on Commands >> Request Connection Status - this will make a pop up appear on the users screen. Click the 'yes' option and select Admin
   
    
   
   
10. Close all Reckon programs. Search for qodbc in the start menu and open the QODBC setup screen. This will start the same window as you had opened previously
    
    
     
    
    
11. Make sure the company file is mapped otherwise we can't pull data unless Reckon is open
    
    
     
12. On the reports-admin overview screen set the connection string as follows:
     
    
    
13. The data should now be able to dump. In slyncy-admin, go to the connector and 'queue' the data for the first time. This will cause a windows warning to show on the client PC. Click 'ok/allow' on this screen.
    This should only happen the first time.
    
    

...