Post reply

DTC ??

  • September 15, 2003 at 3:52 am

    #81047

    Having just moved some db's to a new server - the application accessing the server keeps returning the following error:

    Could not start a transaction for OLE DB provider 'SQLOLEDB'

    The DTC is running, so what else could be causing this error?

    Thanks in advance.

  • September 15, 2003 at 5:36 pm

    #474273

    How is your app connecting to the server? Are you sure you're connecting to the new server?

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 15, 2003 at 5:43 pm

    #474275

    The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transaction.

    The MS DTC service coordinates the proper completion of the distributed transaction to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased.

    Check the MDAC version of both application and database server. You may need install SQL Server client tools to the application server.

    Edited by - allen_cui on 09/15/2003 5:52:16 PM

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

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