HTTP Web Server: Lotus Notes Exception - You are not authorized to use the server.
According to help, I should be able to specify the server name for Domino ODBC source.Is there any configuration I need to do on either server?. I am trying to access our administration server, from one of our secondary servers.
Make sure your “Maximum Internet name and Password” property in the Access Control settings for the source DB has the proper access level set. The default level is “Editor”.
I tested with Manager access level and I still get the same message.
Nathan,
When you say I can only use an agent call, I cannot use this formula on the form then?. I wonder why they did not say so in the help.Do you see any other way I can access a column from a different server?
I believe it is covered in the help. You can’t make the call to a remote server. If it’s @DbColumn(“”; “” : “APPS/DATABASE.NSF”; etc…) then you’re fine.
If you don’t know how to do it in an agent off the top of your head, I’d suggest exploring another route altogether (such as structuring your form to allow the remote client to retrieve the values directly, then incorporate via DHTML.) It’s going to be a heck of a hack to get an agent to deliver the information where you want it on a form.
To perform a lookup (from the workstation) on a Domino database that resides on a server, include the server plus the path and file name as a text list, as in “SERVER”:“DATABASE.NSF.”
So when they say workstation, does it mean you can do from a client and not from a browser?
[So when they say workstation, does it mean you can do from a client and
not from a browser?]
That’s correct. “Workstation” means Notes client workstation. All @functions
in a browser context are not executed by the browser itself (which has no
understanding of Domino @functions,) but by the server’s HTTP rendered before
sending the resulting HTTP to the client.
[I wish they would let it work may be by establishing a trust relationship
or something!]
They do. In agents. That’s why you can do it in agents, but not directly on a
form.
The problem is that the agent model will basically force you to run the agent
(via a WebQueryOpen) on your form, then plug the result into some field on your
form, then display that result in your dialog.
It’s possible, just comparatively complicated to what you’re trying to do.
Subject: @dbcolumn and access another server - works with a trust though!
Hi Nathan,
Just wanted to let you know, I put the seconadry server as trusted server on our administartion server and I am able to access he column values froma database on the administration server now!. At leaset now I know in scenario it works.
This may be different with the trusted agent rules in D6, but in prior versions, this type of call was simply not permitted at all. A server cannot lookup information from another server real-time. This would break the security model for Notes, since the target server would only be checking the access level of the calling server, and not the individual user.
If you can do it in D6 at all, it will only be through an agent call.