June 11, 2009 at 3:47 pm
Hello,
I have a question, on insertion of data from Client 1 I received a Foreign Key Violation error which was presented in VB dialog box. while this dialog is displayed all other clients are unable to insert or update data in the tables affected. Can you make any recommendations on how this should be handled?
I am thinking this is dues to index being locked or something?
Sql Server 2000 on Windows Server 2003
VB6.
June 11, 2009 at 8:17 pm
Hello,
My first guess is the Message Box is being displayed while a Transaction is open - worth checking anyway.
If so, do you have control over the Source Code i.e. can you change it to close (presumably rollback) the Transaction before the Message Box display?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply