I am connecting with the MSSQL server and using the code attached. Whenever I get the RecordsetPtr , should I close like (pRdSet ->Close() ) within the function when done?
I am keeping the "_ConnectionPtr cn;" open globally and accessing the database using local RecordsetPtr on multiple threads (above 100)
Could you please advice me on this?
pRdSet = cn->Execute(btSQL,&bcnstr,0);