Windows Service and sharing connectivity across the Program

[novice123]

Hi,

We are using a COTS (Commercial Off the shelf software). This software package has a database and an front-end application. They have provided an API for external applications to access the data from database.This API comes as Windows service.


When i want to programmatically make a connection via API. I create an instance of API and just say connect

    IAPIPtr m_APIObject;
    m_APIObject.CreateInstance(__uuidof(APIName));
    m_APIObject->Connect("test","test12");

There are 4 external programs we have written to inegrate with the third-party application . Each of these application are self-contained and each of them make their own instance of the API and connect to it. Since we have only API connection license, when one application is running, the remain 3 shut-down.

We want to share the API connection across the programs. Can this be done ? If yes, how can this can be done ?.

  -----------                       -------------
  |  Prog1 |                     |   Prog2   | 
  |            |                     |               |
   ----------                        -------------
       |                                     |
       |                                     |
      V                                    V
------------------------------------------
|  Common API Connection         |
|                                                  |
-----------------------------------------

Thanks in advance

[x8086]

hi ,
well it is not possible to share connection form the .dll because Dll function
call are in-process function calls it means dll will be loaded in the same
memory location of the calling programm.

ok now you want to share a connection try to find out if the connection
can be open by ODBC instade of Api call , in ODBC by connection pulling
you can restrict number of connection open and re-use of existing
connections.

hope it helps

Regards,
x8086