Thanks nntp!

<nntp> wrote in message news:#x9nW5OQDHA.1560TK2MSFTNGP12.phx.gbl...
> just issue it as a sql command "SET ARITHABORT ON"
>
> (Connection.Execute method)
>
> "Peter Crickman" <peter.crickmanjhuapl.edu> wrote in message
> news:KgIMa.33601$0v4.2449984bgtnsc04-news.ops.worldnet.att.net...
> > Hi all,
> >
> > I have a SQL Server table defined with a computed column and an index
was
> > created on the table as well. The table was created with the proper SET
> > statements ON. I have written a stored procedure which contains an
INSERT
> > statement for the table. It was created with the proper SET statements
ON
> > as well and the statement prior to the INSERT statement is SET
ARITHABORT
> > ON. When I execute the stored procedure from the Query yzer, the
> > procedure executes to completion without error. When I execute the
> > procedure through an
> > ADO interface in C++, the Execute method of the Command object fails
with
> an
> > error about the ARITHABORT setting being incorrect. Based on my reading
> of
> > BOL, the ARITHABORT setting is not specified by the OLE DB interface and
> > needs to be setup once the connection is established.
> >
> > How do I set this option through ADO so that the stored procedure will
> > execute properly?
> >
> > Thanks in advance for any help,
> >
> > Peter
> >
> >
> >
> >
>
>