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: 935
Loc: GTA & North America (Remote Su...
(69.158.31.117)
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 Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3651
Loc: Toronto ON, Canada
(74.14.203.173)
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: 935
Loc: GTA & North America (Remote Su...
(69.158.31.117)
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
(70.70.158.140)
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 (), 84 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1874 Members
5 Forums
14562 Topics
71060 Posts

Max Online: 484 @ 10/22/25 07:22 PM
November
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