Poco::Data::Session:Close

Please post support and help requests here.
eduquint
Posts: 49
Joined: 12 Sep 2014, 03:07

Poco::Data::Session:Close

Postby eduquint » 11 Aug 2017, 08:10

Should I close the Poco::Data::Session used to execute a SQL Stored Procedure, immediately after executing the procedure?

I am getting the SQL Error:

===========================
ODBC Diagnostic record #1:
===========================
SQLSTATE = 08002
Native Error Code = 0
[Microsoft][ODBC Driver Manager] Connection in use

And I am wondering if this is happening because I did not close the session and called the method again.

A sample would be:

Code: Select all

   try {
      select << "exec ? = usp_Interface_DatasulTextFile_ReadAll ?", out(errorFound), in(n), into(textLots), now;
      session.close();
      return errorFound == 0 && !textLots.empty();
   }

Is this the correct way of dealing with this problem?

Could anyone help me here?

Eduardo Quintana

Return to “Support”

Who is online

Users browsing this forum: No registered users and 3 guests

cron