I Have two separate processor groups access two separate database on the same SQLServer instance.
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.
I am now researching
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