Post reply

The operation could not be performed

  • March 28, 2011 at 10:05 am

    #147765

    I am trying to insert data from sql to AS400 and get this error:

    The operation could not be performed because OLE DB provider "IBMDASQL" for linked server "AS400DB_JDE" was unable to begin a distributed transaction.

    I can select the data with out any problems. Why I am getting this error message?

    Thank you

  • March 28, 2011 at 1:19 pm

    #1304544

    Do you try with a : Begin Transaction before your insert ?

  • March 28, 2011 at 2:02 pm

    #1304565

    yes I did

    Begin transaction

    insert

    commit

  • March 28, 2011 at 2:46 pm

    #1304588

    Please check your DTC settings.

  • March 28, 2011 at 5:53 pm

    #1304629

    Where do I find DTC

    Thank you

  • March 29, 2011 at 8:27 am

    #1304914

    I just ran this with sql job and it is running, what settings needs to be checked in query analyzer in order to run this statment.

    Thank you

  • April 3, 2011 at 1:24 pm

    #1306828

    To find DTC:

    1. GO Start Menu - Admintrative Tools -Component Services.

    2. Under Component Services, Expand Computer - Right click on My Computer & slect properties.

    3.In the pop u Window, choose MSDTC tab.

    4. check the Security configuration settings options.

    5.Yo have to restart DTC services in order to have those settings effective.

Viewing 7 posts - 1 through 6 (of 6 total)

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