settings: 'ARITHABORT

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

From: Roger (Roger_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Thu, 23 Sep 2004 10:59:07 -0700

Hello folks,
I have a .Net application that executes a store procedure, the code used to
execute fine until I added a clustered unique index to one of the view .This
view uses the base tables that I am trying to insert and delete during my
execution of Store procedure.
It throws up and error

DELETE failed because the following SET options have incorrect settings:
'ARITHABORT'

But I am not able to reproduce the error when I execute the store procedure
from the SQL server and happens only when called from my application.

Does anyone know what might be the problem. or ami missing out something

Regards
Roger

Relevant Pages

  • ADOConnection TimeOut 30 second, no way to change it ???
    ... i use ADOConnection component to connect to SQL Server and using TQuey to ... When i execute the store procedure, it look like the setting is no effect ...
    (borland.public.delphi.database.ado)
  • Re: Insert and update dont work
    ... > execute this store procedure, when I run the application and execute the ... > and after I see the datagridview and the new row is there, ... > insert or delete or update rows in SQL Server 2005 data base using C# ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO - lost records with asynchronous fetching
    ... the problem is that I execute a TADOStoredProc ... Furthermore AsyncFetch and AsyncFetchNonblocking set to True doesn't allow ... I don't need to show records, only to execute the store procedure. ...
    (borland.public.delphi.database.ado)
  • Records lost in an ADOStoredProc
    ... I have a situation, I execute a TADOStoredProc ... Furthermore AsyncFetch and AsyncFetchNonblocking set to True doesn't allow ... I don't need to show records, only to execute the store procedure. ...
    (borland.public.delphi.database.ado)
  • Update or Insert in tableadapter not working
    ... Hi, I have a store procedure to insert, and I use tableadapter to execute this store procedure, when I run the application and execute the sp with: ... or Any idea to execute the store procedure to insert or delete or update rows in SQL Server 2005 data base using C# 2005. ...
    (microsoft.public.dotnet.framework.adonet)