I was surprised, too!
Who_could_suspect_something_like_that? shityiiiii
[Non-text portions of this message have been removed]
Who_could_suspect_something_like_that? shityiiiii
[Non-text portions of this message have been removed]
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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
Yahoo! Groups Links
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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
Yahoo! Groups Links
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<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
Yahoo! Groups Links
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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<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
Yahoo! Groups Links
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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<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
Yahoo! Groups Links
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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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
Yahoo! Groups Links
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<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
Yahoo! Groups Links
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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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
Yahoo! Groups Links
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Links
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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Links
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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
If you are just querying data and not actual doing any updates to the
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
I'm actually writing to the IM tables in Vantage, that's why I'm setting
the lock to exclusive.
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
If you are just querying data and not actual doing any updates to the
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12977g4jg/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407591/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=716511811>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
the lock to exclusive.
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
If you are just querying data and not actual doing any updates to the
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12977g4jg/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407591/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=716511811>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
That should alleviate the problem then, allowing only one thread access
to that session/application/variable at a time. One thing I ran into
was closing out the CFLOCK tag correctly - otherwise the locks tended to
stay open and eat memory
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 3:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm actually writing to the IM tables in Vantage, that's why I'm setting
the lock to exclusive.
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
If you are just querying data and not actual doing any updates to the
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12977g4jg/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407591/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=716511811>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129obb91c/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407857/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=930622489>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
to that session/application/variable at a time. One thing I ran into
was closing out the CFLOCK tag correctly - otherwise the locks tended to
stay open and eat memory
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 3:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm actually writing to the IM tables in Vantage, that's why I'm setting
the lock to exclusive.
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
If you are just querying data and not actual doing any updates to the
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12977g4jg/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407591/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=716511811>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129obb91c/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407857/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=930622489>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
Thanks Brandon.
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
That should alleviate the problem then, allowing only one thread access
to that session/application/variable at a time. One thing I ran into
was closing out the CFLOCK tag correctly - otherwise the locks tended to
stay open and eat memory
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 3:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm actually writing to the IM tables in Vantage, that's why I'm setting
the lock to exclusive.
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
If you are just querying data and not actual doing any updates to the
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12977g4jg/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407591/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=716511811>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129obb91c/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407857/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=930622489>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129qdjdeq/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103408230/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=322159149>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
That should alleviate the problem then, allowing only one thread access
to that session/application/variable at a time. One thing I ran into
was closing out the CFLOCK tag correctly - otherwise the locks tended to
stay open and eat memory
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 3:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm actually writing to the IM tables in Vantage, that's why I'm setting
the lock to exclusive.
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 5:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
If you are just querying data and not actual doing any updates to the
database, I would set the CFLOCK type = readonly and make sure that the
isolation level for the ODBC driver is read-uncommitted.
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:48 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
I'm using Coldfusion. I'm not sure if you are familiar with Coldfusion
but it has and admin section where you can define datasources. With a
Progress DB because Coldfusion doesn't have the Progress drivers built
in you have to create the datasource in the Windows ODBC Admin and then
in the Coldfusion admin you use an ODBC socket connection to piggyback
on top of the Windows ODBC connection.
Coldfusion has a <cflock> tag that I can set to lock exclusively which I
think should work, I'm used to SQL Server where this isn't an issue
usually.
Ben
-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Friday, December 17, 2004 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
What did you write it in? There are ways to define the isolation level
when setting up the connection in the web app. If you can tell me what
language you are using, I can give you some examples.
Also, how did you define your connection in the web app? Are you
creating the ODBC connection, or using a File DSN for the connection?
Thanks,
Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: Friday, December 17, 2004 2:39 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
It's a web app that I wrote, there aren't options. I just ended up
putting a lock around my queries, I just have to wait and see if this
happens again to see if the locking worked.
Thanks,
Ben
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 4:36 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
No, in the web application software.
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 4:29 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Tools -> options -> Advanced in Vantage?
-----Original Message-----
From: sarah.vareschi@... [mailto:sarah.vareschi@...]
Sent: Friday, December 17, 2004 1:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Failure getting record lock on table
Under 'tools' -> 'options' -> 'Advanced', what do you have your
record-locking set to?
-----Original Message-----
From: Ben Densmore [mailto:densmore@...]
Sent: December 17, 2004 12:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Failure getting record lock on table
Does anyone know how this error can be fixed?
"Failure getting record lock on a record from table PUB.OrderDtl"
I am using an ODBC connection from a web application and every once in a
while this error will pop up. It happens on various tables, the last one
I got happened to be with the OrderDtl table.
In my ODBC connections I have tried changing the Default Isolation level
to repeatable read, read uncommitted and Serializable and I still get
this error on occasion. This really messes my code up at times because I
have things scheduled to run and they can't when this error pops up.
Thanks,
Ben
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129j9b27l/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103394664/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=892710037>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Links
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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=1293o6v92/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103405809/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=487685016>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129eaai8h/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103406236/A=2434971/R=0/SIG=11eeoolb0/*htt
p:/www.netflix.com/Default?mqso=60185400>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2434971/rand=216491274>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129vrdncm/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406464/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=861214647>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129blj2a1/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103406750/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=392450892>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=12977g4jg/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407591/A=2495202/R=0/SIG=11evjk50a/*htt
p:/www.netflix.com/Default?mqso=60188913>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495202/rand=716511811>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<http://groups.yahoo.com/group/vantage/files/>
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129obb91c/M=298184.5639630.6699735.3001176/
D=groups/S=1705007183:HM/EXP=1103407857/A=2495208/R=0/SIG=11egg01lg/*htt
p:/www.netflix.com/Default?mqso=60188914>
<http://us.adserver.yahoo.com/l?M=298184.5639630.6699735.3001176/D=group
s/S=:HM/A=2495208/rand=930622489>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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/.
<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
Yahoo! Groups Sponsor
ADVERTISEMENT
click here
<http://us.ard.yahoo.com/SIG=129qdjdeq/M=294855.5468653.6549235.3001176/
D=groups/S=1705007183:HM/EXP=1103408230/A=2455396/R=0/SIG=119u9qmi7/*htt
p:/smallbusiness.yahoo.com/domains/>
<http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=322159149>
________________________________
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
* 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]