asked on

Remote Server Lookup

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

ASKER CERTIFIED SOLUTION

HemanthaKumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SadCase

ASKER

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?

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.

SadCase

ASKER

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?

SadCase

ASKER

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

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.