Hi All,

Perhaps someone can clarify this for me ....

If I open a connection to SQL Server and set Transactions to Manual with SQLSetProp(), will subsequently created Remote Views respect that setting? That is, will the views use the open connection (if I specify SHARE in the view creation command) or will they open their own connection (losing the Transaction setting)?

Also, are there any implications in keeping open a connection handle to SQL Server until while my data objects are alive as opposed to disconnecting until such time as I need to send updates.

TIA

Liam