RDBMS and Composite Application

HCL Domino Domino Forum
1

Hello,Is it possible to integrate MS-Access or MS SQL server in Lotus notes 8 (as composite application)? If this is possible, please provide me a sample database or any other assistant to learn this new feature.

Thanks

-Mohammad Ashfaq

2

Subject: Eclipse

You can do this in many ways depending onm how you want the UI to look.

  • Create a Notes form and do the sql query using Lotusscript or java.

  • Create an Eclipse component using SWT. search eclipse plugins in google for example how to do this. I do beliver there are SQL plugins available for Eclipse, if you know Java you can easily port it to Notes 8.

Thomas

http://www.notessidan.se

3

Subject: Java!!!

Thanks for your reply. I am not a Java programmer and I think eclipse is only based on Java programming.

My scenario is that for example:

I have Leave Application which is design in Ms-Access database. Now I am trying to build composite application in Lotus notes 8 which have multiple NSF components and Ms-Access database should be wired with these other NSF component.

I do not know the mechanism how to convert Ms-Access database into component so that it will be wired with other one.

-Mohammad Ashfaq