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.