Solved

SETUSERID/USERID functions require one connected db or db argument.

Posted on 2012-04-10
5
294 Views
Last Modified: 2012-09-02
Progress Version Number: 10.1C

So far we have been using single database. Now we want to connect to multiple database.
I had created the second database and When i connect to multiple database i get the follwing error.

** SETUSERID/USERID functions require one connected db or db argument. (691)

Since i have the keywork "Userid" in several programs, it will be impossible to change them to userid("dbname").

Is there any other solution?

Thanks
0
Comment
Question by:hawkerpac
  • 2
5 Comments
 
LVL 27

Accepted Solution

by:
tliotta earned 500 total points
ID: 37834318
Is there any other solution?

Not that I'm aware of.

...it will be impossible to change them...

I assume that by "impossible" you mean that it will take extra work. Or can you elaborate?

Tom
0
 

Author Comment

by:hawkerpac
ID: 37834996
With limited resource we have its not possible to change the keyword "userid" which is used in more than 3000 programs. Since we had single database, userid worked fine. Now that we want to split the database , we have to change all the programs whcih has userid to
userid("db1").

So i want to know if there is any other way.

Thanks
0
 

Author Comment

by:hawkerpac
ID: 38029046
We went ahead and changed the programs to refer userid(dbname).
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

773 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