Post reply

Getting error "Cannot create new connection because in manual or distributed transaction mode" while executing query with linked server

  • February 20, 2008 at 6:03 am

    #378672

    Hi all,

    When I execute following query:

    select distinct

    *

    from

    where

    where LTRIM(RTRIM( )) collate database_default NOT IN

    (select distinct (LTRIM(RTRIM( )) collate database_default ) as data

    from [ = '2227')

    get the following error:

    OLE DB provider "SQLNCLI" for linked server "S1" returned message "Cannot create new connection because in manual or distributed transaction mode.".

    Msg 7320, Level 16, State 2, Procedure StoredProc_p, Line 10

    Cannot execute the query "SELECT "Tbl1006"."SomeID" "Col1210","Tbl1006"."SomeNo" "Col1211","Tbl1006"."SomeDate" FROM "DB"."dbo"."TBL" "Tbl1006" WHERE "Tbl1006"."SomeID"=?" against OLE DB provider "SQLNCLI" for linked server "S1".

    Any one have idea about this error and how can this be resolved.

    Best Regards,

    Hemant.

  • March 11, 2008 at 10:12 am

    #788103

    Try to replace NOT IN with NOT EXISTS

  • June 9, 2008 at 8:20 am

    #826124

    I'm getting a similar message when trying to run an update statement where part of my WHERE clause is a query against a linked server. I've done this database many times in the past with no issues. I recently upgraded the server to SQL Server 2005. The linked server is still on SQL Server 2000. Any ideas?

  • April 8, 2010 at 10:46 pm

    #1148806

    Let your read this article :

    http://support.microsoft.com/kb/272358

    Regards,

    Eko Indriyawan

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

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