Solved

Remote Server Lookup

Posted on 2004-10-21
199 Views
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
0
Question by:SadCase
    6 Comments
     
    LVL 24

    Accepted Solution

    by:
    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..

    ~Hemanth
    0
     

    Author Comment

    by:SadCase
    Hi,

    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?
    0
     
    LVL 31

    Expert Comment

    by:qwaletee
    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.
    0
     

    Author Comment

    by:SadCase
    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?
    0
     

    Author Comment

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

    Expert Comment

    by:qwaletee
    SadCase,
    > 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.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

      In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
    Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
    With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
    Want to pick and choose which updates you receive? Feel free to check out this quick video on how to manage your email notifications.

    875 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