Mailing List Archive: Zope: DB

mxODBC DA + SQL Server + "ARITHABORT"

Index | Next | Previous | View Threaded

phil at xfr

Jul 13, 2006, 4:35 AM

Post #1 of 2 (1288 views)
Permalink

mxODBC DA + SQL Server + "ARITHABORT"

Hi All,

I've recently updated the mx ODBC DA to 1.0.10, and am suddenly seeing
(for one single ZSQL method) the error: -

('42000', 1934, "[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT
failed because the following SET options have incorrect settings:
'ARITHABORT'.", 6113)

Unfortunately, I have no idea where "ARITHABORT" would be set - it looks
like an option at a deeper level than the DA or ZSQL method.

Has anyone got any suggestions as to how to troubleshoot this?

N.B. I should say that in this case I have come to the list before
spending much time on it, because it is blocking a critical business
process!

--

Regards,

PhilK

"Human language continually changes, innit."
- Stephen Juan
_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

phil at xfr

Jul 14, 2006, 12:28 AM

Post #2 of 2 (1209 views)
Permalink

Re: mxODBC DA + SQL Server + "ARITHABORT" [In reply to]

Hi All,

Philip Kilner wrote:
> I've recently updated the mx ODBC DA to 1.0.10, and am suddenly seeing
> (for one single ZSQL method) the error: -
>
> ('42000', 1934, "[Microsoft][ODBC SQL Server Driver][SQL Server]INSERT
> failed because the following SET options have incorrect settings:
> 'ARITHABORT'.", 6113)
>
> Unfortunately, I have no idea where "ARITHABORT" would be set - it looks
> like an option at a deeper level than the DA or ZSQL method.
>
> Has anyone got any suggestions as to how to troubleshoot this?
>

Just to close this down - this problem was related to a damaged Zope
instance - later in the day, other problems became apparent. Addressing
those problems eliminated this error.

--

Regards,

PhilK

"Human language continually changes, innit."
- Stephen Juan
_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads