I want to create an ActiveX server using VB6 that keeps some open connections to an Oracle server.
Many clients will create instances of the server on the same machine in the same time.
Each client will try to get an unused connection. If all the connections are used - it will wait. If he gets a connetion - it locks it until he finishes the query.
I need the array of boolean flags(used/not used flag) to be shared for all the instances. Managed to do it by declaring the array in Moudle.
Will each instance use another thread/process (I want the queries be executed in the same time)??
Do I need to use Mutex/Shemaphore/Critical Sections to protect the access to the shared memory?
What's the meaning of the threads number in Project->Options??