dll mts and oracl

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?
lobosAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
modderConnect With a Mentor Commented:
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
 
rovermCommented:
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
 
lobosAuthor Commented:
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
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
rovermCommented:
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
 
lobosAuthor Commented:
I don't think we assign a user in MTS. when we created it we used.

Interactive User
0
 
rovermCommented:
Does the interactive user (the user logged on to the machine where MTS is running) have rights on Oracle ?
0
 
rovermCommented:
lobos:
Is your problem solved ?

D'Mzzl!
RoverM
0
 
lobosAuthor Commented:
Actulled we took a completely different route.....we adjusted the code and made 2 seperate calls, that seemed to have fixed this.
0
 
rovermCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.