Professional Web Applications Themes

Error: Cannot create new connection because in manual or distributed transaction mode - ASP Database

Luke, The first & second SP's both return a Scope_Identity() value for the record that the SP Inserts. However, I ignore the first one, but need to act on the second one. If I ignored the returned value from the second recordset, I could continue to use the original connection. I understand what you mean about the connection potentially being occuped, but I'm unclear as to how you think I should check this. Thanks Chris "[MSFT]" <lukezhanonline.microsoft.com> wrote in message news:eQwtUsrGEHA.2308cpmsftngxa06.phx.gbl... > Hi Chris, > > From another post, I know you have temporarily get around this problem by > ...

  1. #1

    Default Re: Error: Cannot create new connection because in manual or distributed transaction mode

    Luke,

    The first & second SP's both return a Scope_Identity() value for the record
    that the SP Inserts.

    However, I ignore the first one, but need to act on the second one. If I
    ignored the returned value from the second recordset, I could continue to
    use the original connection.

    I understand what you mean about the connection potentially being occuped,
    but I'm unclear as to how you think I should check this.

    Thanks

    Chris

    "[MSFT]" <lukezhanonline.microsoft.com> wrote in message
    news:eQwtUsrGEHA.2308cpmsftngxa06.phx.gbl...
    > Hi Chris,
    >
    > From another post, I know you have temporarily get around this problem by
    > creating a new connection for the SP. My question is, if the second SP
    > didn't return a Recordset, is there going to being such a problem? Since
    > the new connection can work, the original connection seems to be
    "occupied"
    > by something. It looks to me that we may check the recordset first.
    >
    > Luke
    > Microsoft Online Support
    >
    > Get Secure! [url]www.microsoft.com/security[/url]
    > (This posting is provided "AS IS", with no warranties, and confers no
    > rights.)
    >

    CJM Guest

  2. #2

    Default Re: Error: Cannot create new connection because in manual or distributed transaction mode

    Hi Chris,

    You may check the connection's State after it execute the second SP, for
    example:

    Do While <some condition>

    sSQL = "Exec etc"
    oConn.Execute sSQL

    sSQL = "Exec etc"
    rs = oConn.Execute (sSQL)

    Response.Write oConn.State

    sSQL = "Exec etc"
    oConn.Execute sSQL <---- fails here

    sSQL = "Exec etc"
    oConn.Execute sSQL

    Loop

    To see if it is in correct state (ready to execute next SP). Additionally,
    you may try a client side cursor for the connection object to see if it
    will help.

    Luke
    Microsoft Online Support

    Get Secure! [url]www.microsoft.com/security[/url]
    (This posting is provided "AS IS", with no warranties, and confers no
    rights.)

    [MSFT] Guest

Similar Threads

  1. Distributed mode install
    By dday in forum Coldfusion - Getting Started
    Replies: 3
    Last Post: July 1st, 12:56 PM
  2. Distributed Transaction in different web services
    By Avanish Pandey in forum ASP.NET Web Services
    Replies: 1
    Last Post: November 10th, 08:21 AM
  3. Replies: 0
    Last Post: June 25th, 02:31 PM
  4. Distributed Transaction Error
    By dh kim in forum ASP Database
    Replies: 1
    Last Post: September 9th, 03:38 AM
  5. SIMULATING DISTRIBUTED TRANSACTION FAILURE
    By Brit Pop in forum Oracle Server
    Replies: 1
    Last Post: December 18th, 04:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139