Help! What's this error?
-
Hi! I'm facing an error when i'm testing my program. The error is: If i query, insert ... a big sum of data forward and backward from my SQL Server to my app continuous, a little later, my app can't do any query to SQL Server anymore (even a simplest query string : select * from ...). I don't know why it is happened? Anyone can help me please! I'm too anxious! I don't want my app just can process with a little data :(( Thanks! :) (I'm sorry if my English is too bad :sigh:)
-
Hi! I'm facing an error when i'm testing my program. The error is: If i query, insert ... a big sum of data forward and backward from my SQL Server to my app continuous, a little later, my app can't do any query to SQL Server anymore (even a simplest query string : select * from ...). I don't know why it is happened? Anyone can help me please! I'm too anxious! I don't want my app just can process with a little data :(( Thanks! :) (I'm sorry if my English is too bad :sigh:)
You didn't mention what language your application was written in. Are you remembering to close your connection to the database when you are finished with it. If you are using a .NET language such as C# or VB.NET are you callng Dispose on your connection object? Michael CP Blog [^] Development Blog [^]
-
You didn't mention what language your application was written in. Are you remembering to close your connection to the database when you are finished with it. If you are using a .NET language such as C# or VB.NET are you callng Dispose on your connection object? Michael CP Blog [^] Development Blog [^]
Yes, i did remember close the connection when i am finished but i don't understand the dispose() you recommended here. When i want to query or insert database, i often code it like this: conn.open(); comm.ExecuteNonQuery(); conn.close(); Am i missing something ? :confused: My application was written in C#. Thanks your reply :)
-
Yes, i did remember close the connection when i am finished but i don't understand the dispose() you recommended here. When i want to query or insert database, i often code it like this: conn.open(); comm.ExecuteNonQuery(); conn.close(); Am i missing something ? :confused: My application was written in C#. Thanks your reply :)
SqlConnection Dispose[^] Michael CP Blog [^] Development Blog [^]
-
SqlConnection Dispose[^] Michael CP Blog [^] Development Blog [^]