Using Lotusscript to access a database on another server

HCL Domino Domino Forum
1

Hi

I am trying to access a database on another server in Lotusscript. This script is scheduled in an agent. Whenever the script gets to to code to access the database object it says “database has not yet been opened”.

I have searched this forum and found out that it is not possible to use a scheduled agent to access a database on another server.

Is this true? or is there a way in lotusscript (scheduled) to access a database on another server?

Regards

2

Subject: Using Lotusscript to access a database on another server.

Patrick,

This was true prior to R6. But since R6 it is possible. Check the first section of this article for more info (‘Accessing remote servers’).

Regards,

René

3

Subject: RE: Using Lotusscript to access a database on another server.

Two options. Set up your servers as Trusted (as in Rene’s post) or create a Replica Copy of the other database on your server.

4

Subject: RE: Using Lotusscript to access a database on another server.

Hi

Thank you for the tip.

So basically this means that if I have a scheduled agent running on server X and that agent tries to acces a database on server Y it will only work if server Y trust server X?

If that is the only way to accomplish an access connection between 2 servers through a scheduled agent then I have a problem. because the company I work for have very strict rules regarding security and they will never trust any server from a particular server.

isn´t there a workaround or another alternative?

Regards

5

Subject: RE: Using Lotusscript to access a database on another server.

Well,we are talking about basic security concepts of Lotus Notes here… if you are not allowed to access a database (i.e. because you are not in the ACL or the server can’t even recognise you because you are not listed in its directory), then this is how things should be…

Kind regards,

Th.

6

Subject: RE: Using Lotusscript to access a database on another server.

Hi

The thing is that the id that is used to sign the scheduled agent does has right to access the database on the other server. The id is in a group that is in the ACL.

7

Subject: RE: Using Lotusscript to access a database on another server.

… and that would be great if the user was running the agent, but he/she’s not – the server is. The server needs to be trusted, period, if the agent is scheduled or a web agent or is triggered by a scheduled or web agent.

8

Subject: RE: Using Lotusscript to access a database on another server.

ok,

I understand that.

Thank you for the lessons.

9

Subject: Using Lotusscript to access a database on another server.

When you say another database - do you mean another Lotus Notes Database or another DB tool all together (e.g. Oracle, MySQL, whatever)?

If it’s another Lotus Notes database on a server in the same domain, this can definately be done… I do it all the time…

Set db = New NotesDatabase(“ServerName”, “path\subpath\filename.nsf”)

The biggest mistake I see made is people forgetting you need two 's for the path.

10

Subject: RE: Using Lotusscript to access a database on another server.

Hi

It is another Lotus Notes database on another Lotus Notes server.

In the code I use I have double ´/´ for the filepath.