Search results for query: *

There is a boolean in the "e" event arguments that is usually named "Cancel" e.Cancel = True Set this to True, I believe. I am doing it from memory. You should check help on this. That will keep the form open. Ken

Before you open a connection, you must set the connection string. OLEDB example: Dim strConnection as string Dim M_Server as string = "Server Name" Dim M_Database as string = "Database Name" Dim Password as String = "USER Password" Dim UserID as string = "User...

Thanks DotNetDoc I will review my SP with this in mind. Bueller, My connection is as follows: strConnection = "Data Source=" & M_Server & ";Initial Catalog=" & M_Database & ";User Id=" & UserID & ";Password=" & p_Pwd & ";&quot...

Hi, I get the same error, but only when I execute a certain SP. I am using SQL Server 7.0 with VS.net (VB and C# apps) It does not always happen, but once it appears it persists until I reboot or disable-re-enable like you mentioned. I have a few items I plan to try. One: I do not have this...

I am not huge fan of the rules in SQL Server because it is another location (and often forgetten area) that needs to be considered in future changes and updates. As long as you set a default value and then implement a trigger that sets the field to a default value if it is equal to zero, then...

Use the Dataset concepts available in C# (VS.net) There are some very nice features of using datasets that allow you to accomplish this task (and many more tasks!) Ken

Joe, Did you ever resolve your problem? I am getting a similar error (General Network Error; Error 11) using SQL server 7.0 when running certain SP's from a .net application. It's works most of the time, but occasionally I get this error. Once the error occurs, it seems to persist. The SP...