Accessing NSF data from Delphi application?

HCL Domino Domino Forum
1

Hello,

we need to access NSF database from Delphi. Running Domino 8.5. The only thing we need to do is to read one field data from that NSF database. We don’t have much of Notes developers at our disposal but we can do certain changes on it. What would be best, quickest way to do this ?

Thank you,

damiri

2

Subject: Connect using OLE

It should be easy just to connect to your DB and read that entry as similar described here:delphi3000.com

3

Subject: Connect using OLE, version 8.5

this is pretty much old post. However, there are some missing units which are required like Domino_TLB which we don’t have. This must be VCL but we don’t have it. Can you please let me know if you have more info on this …

4

Subject: connect using OLE

The Domino_TLB is a type library which was delievered with Notes v5.x. You can install it in Delphi by following the steps:

→ Components

→ install ActiveX

Search for the Lotus ActiveX and press the install button. But anyway, I will try to figure out how to read the field and as soon as I have a solution, I’ll let you know.

5

Subject: It depends on more circumstances

is this a client side access - you might want to try via com than, if it is serverside, you could do http access, and of course there is a SQL driver (a very slow one, but still)…

Or you could contact someone in the know of delphi and notes, if you have a budget. like www.ligonet.ch

6

Subject: client side access

Our budget is very, very limited. What we need to do is to read value of one field in NSF database. Can you point me to right direction with COM ? We have very Delphi experienced people and with Lotus Domino we were dealing only from administration point, not development.

damiri

7

Subject: I can’t realy point you, but there was symple LotusScript code to

get a notessession or the username of the logged in user from a few lines of VBA in Excel. To me this feels like a good start and I would guess it can be found in google - First hit when searching for ‘VBA Notessesion’ e.g is this one

http://www.fabalou.com/VBandVBA/lotusnotesmail.asp

I would expect an experienced com developer to get an idea on what to do from this (but of course can be wrong)