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

Registered: 06/15/07
Posts: 895
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 Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3504
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 Virtuoso

Registered: 06/15/07
Posts: 895
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: 10493
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 (), 98 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1848 Members
5 Forums
14242 Topics
69746 Posts

Max Online: 359 @ 11/18/19 09:08 PM
May
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 31