Support Questions
Find answers, ask questions, and share your expertise

Two DBCPConnectionPool for SQLServer in different ProcessorGroups one never stops Enabling

Two DBCPConnectionPool for SQLServer in different ProcessorGroups one never stops Enabling

Explorer

I Have two separate processor groups access two separate database on the same SQLServer instance.

92897-settings.png

I have created two DBCPConnectionPool with the only real difference being the Database name in the SQLServer connection string.

One works the other when trying to enable stays enabling all the time.

I am sure this relates to something can only be used once but I am unsure.

Help appreciated.

Lee

92898-enabling.png

1 REPLY 1

Re: Two DBCPConnectionPool for SQLServer in different ProcessorGroups one never stops Enabling

Explorer

I am now researching

DBCPConnectionPoolLookup 1.7.1

but I can find no help on this at all.

How does one use it? I want to have DBCPService defined and then Use

DBCPConnectionPoolLookup 1.7.1 with variable database.name to call to allow execution of sql.

It seems can't have two DBCPConnectionPools with same ODBC driver