Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

dll mts and oracl

Posted on 2001-08-11
9
Medium Priority
?
344 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
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

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

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

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.
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
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…
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…
Suggested Courses
Course of the Month10 days, 6 hours left to enroll

569 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