All geek questions in one place

ODBC - multiple connections from the same application to the same data source

I vaguely remember reading somewhere (in the MSDN ODBC documentation?) That one application cannot make more than one connection to one data source. It seemed to me that I needed one connection that all application threads would have to use. I tried to see this information, but I can no longer find it. Does anyone know / remember how this works?
All this can become a problem in our application, as some of its flows will be dynamically connected to the data sources of their choice. I do not want to see random connection errors if two of them connect to the same source at the same time, so I would like to double-check this information.

+3
source share
2 answers

Perhaps the statement you are talking about in the MSDN documentation is the one that says that only one statement can be active in one connection, It says:

Multiple active connection requests

After SQL Server has received the instruction, the SQL Server TDS protocol does not accept any other instructions from this connection until one of the following events occurs:

  • The client application processes the entire set of results.
  • The client sends an operator informing the server that it can close the rest of the result set.

, , ODBC , SQL Server , .

ODBC API-, . , SQL Server .

. , .

+2

, ODBC . , - , .

+1

Source: https://habr.com/ru/post/1743211/

More articles:


All Articles