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
SadCaseAsked:
Who is Participating?
 
HemanthaKumarCommented:
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
 
SadCaseAuthor Commented:
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
 
qwaleteeCommented:
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
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
SadCaseAuthor Commented:
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
 
SadCaseAuthor Commented:
Hmmm I've done it HemanthaKumar's way using replicas and Thanks to both of you for replying. Have a good day :)
0
 
qwaleteeCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.