Post reply

Arithabort setting for a DMO connection

  • March 23, 2004 at 8:31 am

    #84847

    Hello,

    I'm using DMO to BCP some data/tables between databases.  It seems that I need to alter the ARITHABORT and QUOTED_IDENTIFIER session settings.  I've determined that I can do this for QUOT_ID with object.QuotedIdentifier = True/False.  I cannot find an equivalent for ARITHABORT that makes the change for the session only.

    Can anyone help please?

    Thank you.

     

  • March 26, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • March 26, 2004 at 1:20 pm

    #500733

    Yes I only found how to set for server and database however this might work.

     

    DMOSQLServerObject.ExecuteImmediate "SET ARITHABORT ON"

     

    Which in profiler did run and will stay in effect until my connection is closed ot I SET OFF.

     

    Hope it helps.

  • March 26, 2004 at 1:51 pm

    #500747

    Thanks - I've resolved it though.  When I split my ActiveScript components up in the DTS package it started working with the error that made me think I needed to turn it off.

    I was doing too much in a single component.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply