Disable Server Error Messages to Client App (VB)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi people!


Can anyone help me with this one? Using SQL Server 2000 and VB5,
calling a stored procedure from VB code. When a message occurs like:

Server: Msg 515, Level 16, State 2, Procedure Ve_KarticeIsplate, Line
235
Cannot insert the value NULL into column 'konto', table
'ibis.dbo.promkred'; column does not allow nulls. INSERT fails.
The statement has been terminated.

VB freaks out, looses the connection to server and stops the execution.

I want to be either be able to disable this message or to ignore it
from client app (using ADO for connection)...
(Simply to ignore the error so that the procedure runs further
regardless of errors)

Thanx...

.

Relevant Pages

  • Re: Checking for return codes
    ... The last generated key in a SQL Server can be found by calling "Select ... In the stored procedure I would like to run a select to ... select in the SQL Server stored procedure to my VB .Net procedure? ...
    (microsoft.public.dotnet.framework.adonet)
  • asyncron sql server operations
    ... TAdoComman) so that the programm runs after calling a stored procedure in ... sql server, although the sp is not already yet? ...
    (borland.public.delphi.database.ado)
  • Re: Text datatype
    ... What most people do as a work around is either use multiple varchar columns ... The stored procedure inserts data into the text column in the temp table, ... Wayne Snyder, MCDBA, SQL Server MVP ... CREATE PROCEDURE Calling ...
    (microsoft.public.sqlserver.programming)
  • Disable Server Error Messages to Client App (VB)
    ... Using SQL Server 2000 and VB5, ... calling a stored procedure from VB code. ...
    (comp.lang.basic.visual.database)
  • Re: How to get list of EventClasses in MSSQLServer2000
    ... statement inside a stored procedure has completed.') ... SQL Server statement or stored procedure.') ... Plan','Displays the plan tree of the Transact-SQL statement executed.') ... Login','Occurs when a SQL Server login is added or removed; ...
    (microsoft.public.sqlserver.security)