Passing DB handle between applications
-
Is anyone aware if it is possible to pass a db handle between two seperate applications? And if so how is this accomplished... do you utilize the command line of the CreateProcess command. And if so, how would you pass it (not sure how you would convert it to a string etc). What i am trying to accomplish is not to have to open the same DB on new instances of programs designed to perform certain task. This is an ODBC connection as well. Any insight is appreciated
-
Is anyone aware if it is possible to pass a db handle between two seperate applications? And if so how is this accomplished... do you utilize the command line of the CreateProcess command. And if so, how would you pass it (not sure how you would convert it to a string etc). What i am trying to accomplish is not to have to open the same DB on new instances of programs designed to perform certain task. This is an ODBC connection as well. Any insight is appreciated
Johnny Quintanilla wrote: ...is possible to pass a db handle between two seperate applications? By applications (and the mention of
CreateProcess()), do you mean EXEs? If so, information sent to the spawned application is on the command-line. I'm not sure a handle would be valid across a process boundary.
A rich person is not the one who has the most, but the one that needs the least.
-
Is anyone aware if it is possible to pass a db handle between two seperate applications? And if so how is this accomplished... do you utilize the command line of the CreateProcess command. And if so, how would you pass it (not sure how you would convert it to a string etc). What i am trying to accomplish is not to have to open the same DB on new instances of programs designed to perform certain task. This is an ODBC connection as well. Any insight is appreciated
>Is anyone aware if it is possible to pass a db handle between two seperate applications? Behavior varies from one database to another, from driver, etc etc etc. With Oracle sqlnet api handle may be can passed btw processes, also not supported. SqlLib handle, sqllib api can be passed safely cross boundary and I think is supported. ODBC drivers do NOT support such behavior, it may or may not work with next update of oracle or vendor driver. Proper solution would be to build out of process STA com object, that performs access to database.
-
Is anyone aware if it is possible to pass a db handle between two seperate applications? And if so how is this accomplished... do you utilize the command line of the CreateProcess command. And if so, how would you pass it (not sure how you would convert it to a string etc). What i am trying to accomplish is not to have to open the same DB on new instances of programs designed to perform certain task. This is an ODBC connection as well. Any insight is appreciated
Handles are most often bound to the process in which it was acquired. ODBC handles fall into that category! The post above this one mentions building an out-proc COM server for doing the actual database acces. This may or may not suit your needs. Is it necessary to share the actual connection between the processes? If not, then you can just pass the source DSN to the other processes. Otherwise, the COM server is your best shot. -- Watcha' gonna do, when Hulkamania runs wild on you!?