Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darius_sutherland
Starting Member
17 Posts |
 Posted - 2008-09-10 : 05:21:22
|
| How To Explain...cannot create new connection because in manual or distributed transaction modeThis is ADO/VB stuff so not sure the right place??I have a connection open and a transaction startedI open a recordset then it's looping through this recordset and within the loop attempting to open another recordset, Keyset,Optimistic, here is where the error fails.Strange thing was it used to fail so I performed the open recordset query within the loop on a seperate connection, works 2005 fails on 2000 when the update occurs, with a timeout.Now. Where I was getting the above error msg on 2005 when attempting to open the recordset within the loop on the same connection, now works all of a sudden?It's related to implicit transactions??? Im a bit stumpedIf this isn't the place to post it, could somebody point me to the right place/good place.e.grs.open on MyConnectionLoop Until End Of rs rs_2.open On MyConnection, Keyset, Optimistic - Fails or At Least It Did But Works Now rs_2.Set Some Values rs_2.Update --Here Is Why I Created A 2nd Connection --To Open The Above but the the update then times out on SQL 2000 ont 2005LoopHelp.Thanx in advance..DState Of Mind Photography - It's This, It's That, It's The Otherwww.state-of-mind.co.uk |
|
|
darius_sutherland
Starting Member
17 Posts |
Posted - 2008-09-10 : 06:01:37
|
| Okay.Possible fixed.You can only have 1 read only recordset open on a connection, so for the recordset I am using to loop thru I set the cursors and such to another type and then open my other recordset within the loop and all seems well.Shall see if SQL 2005 throws up any problems now. So this is for anyone like me that is browsing the internet pulling their hair out..DState Of Mind Photography - It's This, It's That, It's The Otherwww.state-of-mind.co.uk |
 |
|
|
|
|
|
|
|
cannot create new connection because in manual