Topic Options
#64324 - 07/03/20 07:18 AM Cannot run DIC because of ODBC
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
Client is running Adagio modules with the add-on Production Tracker from Garo Group.

Production Tracker resides on the server and checks every minute to see if there are any new or modified orders in O/E, and if yes, automatically sends this information to the Production Tracker software. We use the ODBC module to make the connection to Adagio.

Problem: We cannot run the data integrity checks because the Garo Group is always logged on to Adagio ODBC.

Is there any work-around that would allow us to have ODBC running and still run the DIC?
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#64325 - 07/03/20 07:47 AM Re: Cannot run DIC because of ODBC [Re: Samuel Kopstick]
Bruce Gardner Online   content
Adagio Wizard

Registered: 06/15/04
Posts: 3613
Loc: Toronto ON, Canada
Hi Samuel:

Datacare has an option to run without exclusive access to the data-files. The downside is that it can detect problems but not fix them when running without exclusive access.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#64326 - 07/03/20 09:22 AM Re: Cannot run DIC because of ODBC [Re: Bruce Gardner]
Samuel Kopstick Offline
Adagio Maestro

Registered: 06/15/07
Posts: 920
Loc: GTA & North America (Remote Su...
This is available for those who are running Datacare.
But in this case, the client runs the DIC directly from the modules.
_________________________
Samuel Kopstick
S Kopstick & Associates Inc
Toronto, ON

Top
#64340 - 07/03/20 07:03 PM Re: Cannot run DIC because of ODBC [Re: Samuel Kopstick]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
Hi Samuel,

They’ll have to stop whatever process Garo is using to scan the data since ODBC only locks the files when the tables are actually being read.
_________________________
Andrew Bates

Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 86 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70662 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30