Solved

dll mts and oracl

Posted on 2001-08-11
9
330 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
  • 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
 

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
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now