Click here to Skip to main content
15,860,859 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am working on window application in vb.net which consists 5 modules.When I use update module and click on update button it takes too much of time to process and at last show an error as and:-

"The semaphore timeout period has expired"

I am using a simple query for update process as :-
VB
cmd1.CommandText = "update newpropertyimages set idno = '" & TextBox1.Text & "' where idno='" & ComboBox3.Text & "'"
             cmd1.Connection = con
             cmd1.CommandTimeout = 0
             cmd1.ExecuteNonQuery()
             MessageBox.Show("ID No udated)

And same happens with delete process
plz help me...
Posted
Updated 30-Apr-13 23:44pm
v2
Comments
Keith Barrow 1-May-13 6:15am    
Can you add the stacktrace to your question? You don't normally get this error with sql commands, it could be something in the transport layer that the connection sits on, or be some other semaphore timing out.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900