Biztalk and ODP.net: connection pools and connection strings -

Biztalk and ODP.net: connection pools and connection strings -

we have problem our biztalk applications receive locations , send ports connecting oracle database. run out of connections.

i don't know why, original developers used both wcf-custom , wcf-oracledb, think both utilize odp.net ado.net provider.

since, in ado.net , in odp.net, connection pools keyed on connection string (exact string match, think), connection pool logically shared among send ports , receive locations. since don't have command of connection string itself, have assume connection strings in adapters consistently generated 1 port other.

my questions are:

1- right assume receive locations , send ports can share connection pools, long run on same host instance, and

2- thought grouping similar ports , locations (the ones using same connections strings) 1 host instance?

thank you, michel

based on below website, connection pool indeed determined via uniqueness of connection string: http://www.connectionstrings.com/oracle-data-provider-for-net-odp-net/ (see "specifying pooling parameters")

one way tackle problem or @ to the lowest degree give improve insight, enable odp.net tracing , performance counters. allow clear view on how many connections beingness used in pool(s).

for more info on how enable those, see:http://blog.ilab8.com/2011/09/02/odp-net-pooling-and-connection-request-timed-out/

connection biztalk odp.net pool