Oracle OCI, COM+, dblinks and Multi Threaded Server????

From: Royco <bla_at_bla.nl>
Date: Thu, 26 Feb 2004 15:31:01 +0100
Message-ID: <c1l04k$m1g$1@azure.qinip.net>

Hi,

Situation as follows
- a C++ component with OCI-calls running under the control of COM (w2k)

component is marked transactional
the component connects to database1 but wants to update tables in database2 (through a databaselink).
Oracle version is 8i on client and server

Initially we received an Oracle error 24777 : Use of non-migratable database link not allowed.

After reading some documentation we decided to configure Multi Threaded Server but now the database-server processen are instable. Doing something like "insert into database2 as select from a table in database1" hangs up the database-processes.

Is there some thinking-error in our solution????? How can I make a 'transactional' com-component doing selects and updates in more then 1 database?

roy Received on Thu Feb 26 2004 - 08:31:01 CST