Error in Access using ODBC

Yahoo Archive
1
That is correct, I just has a "similar" issue with one that I did not have
set to that (missed it).

Aaron

-----Original Message-----
From: Heisey, Lois [mailto:lheisey@...]
Sent: Wednesday, November 19, 2003 1:23 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Error in Access using ODBC


I have always set it to Read Uncommitted and that has always seemed to work.
Is that correct?

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, November 19, 2003 12:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Error in Access using ODBC


Did you check the ODBC setting in the system DSN to be sure the "Advanced"
Default isolation level is set correctly?

Aaron Hoyt
Design Standards

-----Original Message-----
From: lois_heisey [mailto:lheisey@...]
Sent: Wednesday, November 19, 2003 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Error in Access using ODBC


Receiving an error.... Failure getting record lock on a record from
table pub. PO detail. #-210015. What does this mean? Oh yes, it
only happens on 1 works station (98). It runs beautifully on XP.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Receiving an error.... Failure getting record lock on a record from
table pub. PO detail. #-210015. What does this mean? Oh yes, it
only happens on 1 works station (98). It runs beautifully on XP.
3
Same Vantage username on both machines? Sometimes when a user has been knocked out of Vantage (system hang or reboot) they leave a "ghost" session under their name which causes problems. You have to kill the old session via ProMon. This might be the cause if same username is being tried on that one workstation.
-Todd C.

-----Original Message-----
From: lois_heisey [mailto:lheisey@...]
Sent: Wednesday, November 19, 2003 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Error in Access using ODBC


Receiving an error.... Failure getting record lock on a record from
table pub. PO detail. #-210015. What does this mean? Oh yes, it
only happens on 1 works station (98). It runs beautifully on XP.



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=12ckndltk/M=267637.4116730.5333196.1261774/D=egroupweb/S=1705007183:HM/EXP=1069351795/A=1853619/R=0/*http://www.netflix.com/Default?mqso=60178356&partid=4116730> click here
<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmail/S=:HM/A=1853619/rand=330393974>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
That appears to be the exact cause of the error. Thanks.

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Wednesday, November 19, 2003 12:14 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Error in Access using ODBC


Same Vantage username on both machines? Sometimes when a user has been
knocked out of Vantage (system hang or reboot) they leave a "ghost" session
under their name which causes problems. You have to kill the old session
via ProMon. This might be the cause if same username is being tried on that
one workstation.
-Todd C.

-----Original Message-----
From: lois_heisey [mailto:lheisey@...]
Sent: Wednesday, November 19, 2003 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Error in Access using ODBC


Receiving an error.... Failure getting record lock on a record from
table pub. PO detail. #-210015. What does this mean? Oh yes, it
only happens on 1 works station (98). It runs beautifully on XP.



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=12ckndltk/M=267637.4116730.5333196.1261774/D=egroup
web/S=1705007183:HM/EXP=1069351795/A=1853619/R=0/*http://www.netflix.com/Def
ault?mqso=60178356&partid=4116730> click here

<http://us.adserver.yahoo.com/l?M=267637.4116730.5333196.1261774/D=egroupmai
l/S=:HM/A=1853619/rand=330393974>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




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



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
5
Did you check the ODBC setting in the system DSN to be sure the "Advanced"
Default isolation level is set correctly?

Aaron Hoyt
Design Standards

-----Original Message-----
From: lois_heisey [mailto:lheisey@...]
Sent: Wednesday, November 19, 2003 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Error in Access using ODBC


Receiving an error.... Failure getting record lock on a record from
table pub. PO detail. #-210015. What does this mean? Oh yes, it
only happens on 1 works station (98). It runs beautifully on XP.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
6
I have always set it to Read Uncommitted and that has always seemed to work.
Is that correct?

-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Wednesday, November 19, 2003 12:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Error in Access using ODBC


Did you check the ODBC setting in the system DSN to be sure the "Advanced"
Default isolation level is set correctly?

Aaron Hoyt
Design Standards

-----Original Message-----
From: lois_heisey [mailto:lheisey@...]
Sent: Wednesday, November 19, 2003 1:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Error in Access using ODBC


Receiving an error.... Failure getting record lock on a record from
table pub. PO detail. #-210015. What does this mean? Oh yes, it
only happens on 1 works station (98). It runs beautifully on XP.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/






Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/