Go Premium for a chance to win a PS4. Enter to Win


Remote Server Lookup

Posted on 2004-10-21
Medium Priority
Last Modified: 2013-12-18
Hi people,

Sorry but I'm back with a problem again. I have a form with a field "User Name". This field is a combobox and is supposed to get its values(names) from a Names Address Book on another server. I keep getting a Remote server lookup not allowed error. After I messed around with the code i started to get Internal Server 500 error. Could this be due to the @DbColumn lookup limit? Anyone knows whats the problem and the solution?

Regards, SC
Question by:SadCase
  • 3
  • 2
LVL 24

Accepted Solution

HemanthaKumar earned 200 total points
ID: 12380489
DBCOlumn and DBLookup doesn't work on server other than the hosted (app) server. One way to do is using a replica copy of the same database on the hosted server.. which is mostly true for names.nsf they are replicated all over the domain.. unless your server is disconnected from this domain

From R6 this limitation is lifted off..


Author Comment

ID: 12383299

So what I'd have to do is to have a replica copy of the names.nsf on the same server as the form? Is there any other way?
LVL 31

Expert Comment

ID: 12390784
Since this is a web application, then yes, there is another way.  But it is complex.  Right now, you are essentially opening up a "dialog box" into the local server NAB, and the dialog box (really just another browser window) returns the selected value into the main form's window.  What you would have to do is open an equivalent dialog box on the other server.
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

ID: 12396613
Hmmm I dont quite understand that. So I'd have to open up a view of the names.nsf in another window and then write codes to return selected value into the main window?

Author Comment

ID: 12398166
Hmmm I've done it HemanthaKumar's way using replicas and Thanks to both of you for replying. Have a good day :)
LVL 31

Expert Comment

ID: 12405031
> Hmmm I dont quite understand that. So I'd have to open up a view of the names.nsf in another window
> and then write codes to return selected value into the main window?

Yes.  As long as thetwo servers share a domain (e.g., myserver.somehwre.com and yourserver.somewhere.com), they can script across windows.

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month12 days, 12 hours left to enroll

971 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