Subject | Error with Stored Procedure with Local Connection |
---|---|
Author | Vincenzo Scarpellino |
Post date | 2004-11-29T13:44:24Z |
IBO 4.5, FB 1.5
I am encuntering a problem when I use my application with a LOCAL
connection, it work fine with TCP_IP.
I have two SP, first perform update and second run a report.
IBOTransaction2.Isolation:= tiConcurrency;
IBOTransaction2.RecordVersion:= True;
IBOTransaction2.LockWait:= False;
IBOTransaction2.StartTransaction;
try
IB_SPUpdateData.ExecProc;
IBOTransaction2.Commit;
except
IBOTransaction2.Rollback;
raise;
end;
IBOTransaction2.StartTransaction;
try
IBOQueryReportData.Open;
IBOTransaction2.Commit;
except
IBOTransaction2.Rollback;
raise;
end;
When it run first time is ok, next it hang all and I am constrain to abort
it in taskmanager and Firebird too, with TCP_IP it work fine.
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Prestiti e Finanziamenti con un semplice click, scopri subito se sei finanziabile cliccando qui
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2910&d=29-11
I am encuntering a problem when I use my application with a LOCAL
connection, it work fine with TCP_IP.
I have two SP, first perform update and second run a report.
IBOTransaction2.Isolation:= tiConcurrency;
IBOTransaction2.RecordVersion:= True;
IBOTransaction2.LockWait:= False;
IBOTransaction2.StartTransaction;
try
IB_SPUpdateData.ExecProc;
IBOTransaction2.Commit;
except
IBOTransaction2.Rollback;
raise;
end;
IBOTransaction2.StartTransaction;
try
IBOQueryReportData.Open;
IBOTransaction2.Commit;
except
IBOTransaction2.Rollback;
raise;
end;
When it run first time is ok, next it hang all and I am constrain to abort
it in taskmanager and Firebird too, with TCP_IP it work fine.
--
Email.it, the professional e-mail, gratis per te: http://www.email.it/f
Sponsor:
Prestiti e Finanziamenti con un semplice click, scopri subito se sei finanziabile cliccando qui
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=2910&d=29-11