Solved

dll mts and oracl

Posted on 2001-08-11
9
335 Views
Last Modified: 2006-11-17
We are using MTS and connect to a database that has a view which points to another database and at that time I think it is trying to use MTS to use another connection but generating this error.....is my thinking right?

Getting this error.
ORA-24777 use of non-migratable database link not allowed

Cause: The transaction, which needs to be migratable between sessions, tried to access a remote database
from a non-multithreaded server process.

Action: Perform the work in the local database or open a connection to the remote database from the
client. "If the multithreaded server option is installed, connect to the Oracle instance through the
dispatcher."

What am I doing?
0
Comment
Question by:lobos
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 12

Expert Comment

by:roverm
ID: 6377363
Sounds to me like a security problem.

What security settings does your component use ? And does that 'user' has access to both databases?

D'Mzzl!
RoverM
0
 

Author Comment

by:lobos
ID: 6379825
you think it's a security thing?
I copied the sql statement from vb in sqlplus and ran it with the same user and got data back........so do you think it's the reason?
0
 
LVL 12

Expert Comment

by:roverm
ID: 6379899
Still think so, because MTS can use it's 'own' user to connect to Oracle, unless you specify a user_name and password in your connectionstring.

Is the user you connect under in SQL+ the same user MTS, or better, the component uses ?

D'Mzzl!
RoverM
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:lobos
ID: 6379998
I don't think we assign a user in MTS. when we created it we used.

Interactive User
0
 
LVL 12

Expert Comment

by:roverm
ID: 6380509
Does the interactive user (the user logged on to the machine where MTS is running) have rights on Oracle ?
0
 
LVL 12

Expert Comment

by:roverm
ID: 6419721
lobos:
Is your problem solved ?

D'Mzzl!
RoverM
0
 

Author Comment

by:lobos
ID: 6422274
Actulled we took a completely different route.....we adjusted the code and made 2 seperate calls, that seemed to have fixed this.
0
 
LVL 12

Expert Comment

by:roverm
ID: 6423133
Hi lobos!

Glad to see that your problem is solved!
Can you please close the question so that all this valuable information goes into the EE database ?

D'Mzzl!
RoverM
0
 
LVL 3

Accepted Solution

by:
modder earned 0 total points
ID: 6452485
Hello lobos,

When you solve your own question it would be appreciated if you could let us know - this time I found out because another participant let me know. Anyway, if you do, I can assist in refunding your points. Which I have done now.

I will make this a PAQ so that others can benefit from it.

Regards

modder
Community Support
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In a recent article (http://www.experts-exchange.com/A_7811-A-Better-Concatenate-Function.html) for the Excel community, I showed an improved version of the Excel Concatenate() function.  While writing that article I realized that no o…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question