I have a dll that connects to the DB (Oracle) via ODBC fetches values & returns values to the caller. All resources are released at class_terminate. When the dll is called from another vbp, connection pooling is not effective. Every time the caller app is closed & opened again, a new connection is opened (old conn still remains free in the pool).<BR><BR>I do have the lines of code to initialise conn pooling <BR>rc = SQLSetEnvAttr(0&, _<BR> SQL_ATTR_CONNECTION_POOLING, _<BR> SQL_CP_ONE_PER_DRIVER, _<BR> SQL_IS_INTEGER)<BR><BR>& release them<BR>Call SQLSetEnvAttr(0&, _<BR> SQL_ATTR_CONNECTION_POOLING, _<BR> SQL_CP_OFF, _<BR> SQL_IS_INTEGER)<BR>along with appropriate declarations.<BR>What should be done to have connection pooling effective when the dll is called?<BR><BR>TIA.<BR><BR>Regards,<BR>S.Malathi