In a multi user environment while executing BeginTrans thru ADO.Begintrans, we get the following error message.

"Cannot start transacton because more than one hdbc is in use - 2147168667"

The occurrence of the error is erratic, and the ADO Provider is MSDASQL(SQL Server). We are using two connections per client.