Hello,

I'm trying to figure out how the data access adapter opens and closes its connection. lets say i do not set KeepConnectionOpen. So does it open when calling a fetch routine then immediately close or does it open once instantiated? Just trying to figure out what class scope to keep my adapter at.

Thanks

When you perform an action on the DataAccessAdapter, If there is a connection to use, it use it, if the connection is already open, it doesn't reopen it. Then the connection is closed if you didn't specify "keepConnectionOpen" and if there is not a transaction in progress.

(Edit) You can download sourcecode to see what exactly happens with the connection.