Subject Error with Stored Procedure with Local Connection
Author Vincenzo Scarpellino
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