By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,884 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

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

P: n/a
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


Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.