DISTRIBUTED REQUEST

Sometimes when i try yo execute a distributed request , I am getting this
error
Impossible de démarre une transaction sur le fournisseur OLE DB 'SQLOLEDB'.
[OLE/DB provider returned message: Impossible de créer une nouvelle
transaction en raison d'un dépassement de capacité.]
Trace de l'erreur OLE DB [OLE/DB Provider 'SQLOLEDB'
ITransactionLocal::StartTransaction returned 0x8004d01d: ISOLEVEL=4096].
can you help me .Do you use connection pooling? Sounds like your connection pool has ran
out of connections and your settings disallow the creation of another
connection.
You can check this out easily by checking the # of active connections
with Enterprise manager and compare it to the max pool size.
/Jo
benamerk wrote:

> Sometimes when i try yo execute a distributed request , I am getting this
> error
> Impossible de démarre une transaction sur le fournisseur OLE DB 'SQLOLEDB
'.
> [OLE/DB provider returned message: Impossible de créer une nouvelle
> transaction en raison d'un dépassement de capacité.]
> Trace de l'erreur OLE DB [OLE/DB Provider 'SQLOLEDB'
> ITransactionLocal::StartTransaction returned 0x8004d01d: ISOLEVEL=4096].
> can you help me .