ARITHABORT....

  • Thread starter Thread starter Ollie Riches
  • Start date Start date
O

Ollie Riches

I have a stored procedure that is being called from ado.net and it is
failing with an exception that is related to the option ARITHABORT - 'UPDATE
failed because the following SET options have incorrect settings:
'ARITHABORT'.

This stored procedure works perfectly fine from query analyzer and from
enterprise manager in sql server. Is this a problem with ado.net?

The database is sql server 2000 with .net framework version 1.1

Cheers in advance

Ollie Riches
 
it appears that an index is causing this to occur but the database is out of
my control is there any other way to resolve this with out removing the
index?

Cheers

Ollie Riches
 
You can try to send a SET ARITHABORT ON on the connection that you use to
execute the stored procedure. Alternatively you can make a command object
(type Text) with commandtext like "SET ARITHABORT ON EXEC procedurename
@par1,@par 2 " when you want to execute the stored procedure.

Marc
 
Back
Top