RetrievalProcedures in a transaction

Posts   
 
    
ianvink
User
Posts: 394
Joined: 15-Dec-2006
# Posted on: 06-Aug-2007 15:02:06   

Hi,

I am getting the following error:

SelectCommand.Connection property has not been initialized. 

when I call a RetrievalProcedure with a transaction.

I have set the ActualConnectionString and tested I am getting good data.


                DbUtils.ActualConnectionString ="Data Source=DDDDDDD;Initial Catalog=DDDDDD;Integrated Security=True;";

Perhaps my use of the transaction object is not correct.

We're importing documents from some other source.

We loop thru a number of imported documents, filling in/saving LLBL objects as we go. If any document is bad, we rollback the transaction Then try the next one.

Do I need to "clear" or "reset" or "new" the transaction object after I Rollback? Once there is a document error, I just move on to the next document to import.

goose avatar
goose
User
Posts: 392
Joined: 06-Aug-2007
# Posted on: 06-Aug-2007 18:36:51   

Hi, I would run a little test to try to reproduce this error, could you explain a little further what you are trying to do?

Goose.