ODBC Record Locking

Yahoo Archive
1
Works perfect, thanks!



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Tuesday, October 26, 2010 7:20 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ODBC Record Locking





Todd, ensure your ODBC driver on the client is set to READ UNCOMMITTED
and you should be just fine.

DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL
v10.0B;UID=sysprogress;PWD=sysprogress;HOST=localhost;PORT=8350;DB=mfgsy
s;DIL=READ UNCOMMITTED

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Todd Gilbert
Sent: Tuesday, October 26, 2010 10:14 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ODBC Record Locking

Recently, an outside consultant helped us develop an Excel-based
production schedule that is generated through an MS Access ODBC
connection to Vantage. It is set to regenerate at night when nobody is
logged so that it doesn't fail due to records being in use.

Occasionally, we need to regen during the day after a bunch of jobs are
released. To do this ourselves we have to kick everyone off of the
system. However, our consultant is able to login to our server remotely
and regen the report without the need to kick everyone off.

Any idea how this is done?

Thanks,

Todd Gilbert

GCM, Inc.

Vantage 6.1

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
Recently, an outside consultant helped us develop an Excel-based
production schedule that is generated through an MS Access ODBC
connection to Vantage. It is set to regenerate at night when nobody is
logged so that it doesn't fail due to records being in use.



Occasionally, we need to regen during the day after a bunch of jobs are
released. To do this ourselves we have to kick everyone off of the
system. However, our consultant is able to login to our server remotely
and regen the report without the need to kick everyone off.



Any idea how this is done?



Thanks,

Todd Gilbert

GCM, Inc.

Vantage 6.1



[Non-text portions of this message have been removed]
3
Set the ODBC connection isolation level to READ UNCOMMITED



Regards,

Stephen



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Gilbert
Sent: 26 October 2010 15:14
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Record Locking





Recently, an outside consultant helped us develop an Excel-based
production schedule that is generated through an MS Access ODBC
connection to Vantage. It is set to regenerate at night when nobody is
logged so that it doesn't fail due to records being in use.

Occasionally, we need to regen during the day after a bunch of jobs are
released. To do this ourselves we have to kick everyone off of the
system. However, our consultant is able to login to our server remotely
and regen the report without the need to kick everyone off.

Any idea how this is done?

Thanks,

Todd Gilbert

GCM, Inc.

Vantage 6.1

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
4
Todd, ensure your ODBC driver on the client is set to READ UNCOMMITTED
and you should be just fine.



DRIVER=DataDirect 4.20 32-BIT OpenEdge SQL
v10.0B;UID=sysprogress;PWD=sysprogress;HOST=localhost;PORT=8350;DB=mfgsy
s;DIL=READ UNCOMMITTED



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Todd Gilbert
Sent: Tuesday, October 26, 2010 10:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Record Locking





Recently, an outside consultant helped us develop an Excel-based
production schedule that is generated through an MS Access ODBC
connection to Vantage. It is set to regenerate at night when nobody is
logged so that it doesn't fail due to records being in use.

Occasionally, we need to regen during the day after a bunch of jobs are
released. To do this ourselves we have to kick everyone off of the
system. However, our consultant is able to login to our server remotely
and regen the report without the need to kick everyone off.

Any idea how this is done?

Thanks,

Todd Gilbert

GCM, Inc.

Vantage 6.1

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]