ADO connection with C++

Other SQL Server Topics
1

Hi All,

I am working with ADO connection with C++ where I connection of DB fetch records and close connection. ,
My porblem is we have to connect, fetch records and close connection every time for single user and we have more than one million users.
Is there any way that we can keep connection alive or have some pooling mechanism running background so we done have to connect always ?

Thanks in advance

2

You can use connection pooling. Documentation and lot of examples are available on the web. For example, see here.

Please do read the documentation and understand the precautions and caveats, e.g. pool fragmentation, need to call dispose etc.