Solved

dll mts and oracl

Posted on 2001-08-11
9
334 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
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 

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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

726 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