Stuart_Johnson
asked on
_STUPID_ Oracle problem
We've just encountered a really stupid error which is only happening on Oracle, and for only one of our Oracle customers. Our customer is using Oracle 8.1.6. The application is written in Delphi 5 Enterprise. Connection to Oracle is via the BDE.
Scenario:
Person 1 logs into our system. Person 2 logs into our system. Person one begins a job. Person 2 begins a job. Person 1 saves the job, Person 2 locks up and will stay that way until Person 1 quits the application.
I really hope some one can help me out with this. It's driving everyone here nuts :)
Stu
Scenario:
Person 1 logs into our system. Person 2 logs into our system. Person one begins a job. Person 2 begins a job. Person 1 saves the job, Person 2 locks up and will stay that way until Person 1 quits the application.
I really hope some one can help me out with this. It's driving everyone here nuts :)
Stu
appendix,
the bde-oracle-native-driver, which comes with d5 enterprise has a bug associated with the autocommit-feature
get the bugfix at www.borland.com/devsupport/bde (a dll replacement) or
get there the latest bde-update
meikl ;-)
the bde-oracle-native-driver, which comes with d5 enterprise has a bug associated with the autocommit-feature
get the bugfix at www.borland.com/devsupport/bde (a dll replacement) or
get there the latest bde-update
meikl ;-)
ASKER
Hi meikl,
Thanks very much for the info! I'll download the DLL now and give it a go.
The autocommit feature you meantioned...I don't seem to have a property with that name. However, the SQLPASSTHRUMODE property has SHARED AUTOCOMMIT as an option. Is that what you were refering too?
Stu
Thanks very much for the info! I'll download the DLL now and give it a go.
The autocommit feature you meantioned...I don't seem to have a property with that name. However, the SQLPASSTHRUMODE property has SHARED AUTOCOMMIT as an option. Is that what you were refering too?
Stu
>SHARED AUTOCOMMIT
yep, this should it be, set it to true,
if you don't like to control the transactions byself
meikl ;-)
yep, this should it be, set it to true,
if you don't like to control the transactions byself
meikl ;-)
ASKER
Meikl,
The options for SQLPASSTHRUMODE are:
NOT SHARED
SHARED AUTOCOMMIT
SHARED NOAUTOCOMMIT
I'm guessing that you want me to set SQLPASSTHRUMODE to SHARED AUTOCOMMIT?
Also, just checked that link you sent. Do we need to download the whole BDE to get this fixed? We're currently running BDE 5.01 and that's the version we've "certified OK" for our product. Using to BDE 5.2 would mean our testing department would be run off their feet testing the entire product again.
Do you know the name of the single DLL we need? Perhaps I can download the new BDE and extract just the required DLL (or won't this work)?
Thanks again mate.
Stu
The options for SQLPASSTHRUMODE are:
NOT SHARED
SHARED AUTOCOMMIT
SHARED NOAUTOCOMMIT
I'm guessing that you want me to set SQLPASSTHRUMODE to SHARED AUTOCOMMIT?
Also, just checked that link you sent. Do we need to download the whole BDE to get this fixed? We're currently running BDE 5.01 and that's the version we've "certified OK" for our product. Using to BDE 5.2 would mean our testing department would be run off their feet testing the entire product again.
Do you know the name of the single DLL we need? Perhaps I can download the new BDE and extract just the required DLL (or won't this work)?
Thanks again mate.
Stu
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Meikl, as always, you've just out shone yourself again. Truely brilliant!
Thank you SO much!
Stu
Thank you SO much!
Stu
well,
glad to helped you,
and also glad you got it work
meikl ;-)
glad to helped you,
and also glad you got it work
meikl ;-)
was a pleasure for me ;-)
meikl ;-)