Hii Everybody…
I m using @dblookup function in web to collect data from
another database locating in another server based on certain
key.so i m writing formula like this…
If(@ClientType=“Web”;@DbLookup( “” : “NoCache” ;“KMSERVER” :“kmreg.nsf” ;“af” ;@Trim
(aut_pno2) ;2);“”)
Above formula not able to collect data form km server.so
anybody face such problem previously, pls help me…
Thanks n Regards
Saswat
Subject: RE: @dblookup used in web application collecting data from different server.
By default, this doesn’t work. It doesn’t work at all before ND6. The reason is that your DbLookup is running with the permissions of the web user (or maybe the permissions of the signer of the form if it’s actually in a web agent that is configured for that), but Server-A (where the DbLookup is running) has no way to tell Server-B (where the data is stored) who that user is. Prior to ND6, there was no handshake for that. In ND6 there is, but you have to bear in mind that since Server-A doesn’t have the user’s ID file and password it can’t really prove to Server-B that it’s really authorized to make requests for that particular user! Server-B needs to be sure that it is enforcing ACL and readernames security correctly for the user, so it’s going to have to trust Server-A to tell the truth about who the user is. This handshake is a powerful tool that lets a server imporsonate any user, and anyone could write code to emulate the handshake so there has to be an extra level of control. Starting with ND6, there is a 'Trusted servers" field on the Security tab of the server document. Make sure that Server-A is entered into that field in Server-B’s server doc. I’m not sure if a reboot of Server-B is required for this to take effect or not.
Subject: RE: @dblookup used in web application collecting data from different server.
Make sure the View First Column is ascending , and the path of the Database is correct . I dont see any Syntactical Error in the code .
Karthik