Solved

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

Posted on 2012-04-10
5
272 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

744 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

11 Experts available now in Live!

Get 1:1 Help Now