Re: Accessing a Lotus Notes Database

If I had to come up with a quick-n-dirty solution for your case, I'd probably forget Linux for now and go with ODBC, ActiveState Perl on Win32, and DBD::ODBC...

Before anyone kills me for saying this, I'll explain:
I checked through CPAN, I noticed that the only mention of a LotusNotes interface was listed as an idea which means there is no available code. Tough break there...

Therefor, it seems that the only imediate solution would be setting up a Win32 server (which I know for a FACT has an Lotus ODBC driver), install ActiveState's distro, install DBI and DBD::ODBC via PPM and you're off! Just don't expect the machine to perform well under stress, after all you will be:
1. On a Windows machine.
2. Using ODBC
3. Loading DBD::ODBC as the 3rd layer

There might be a way of doing this via Linux and ODBC as well, but I can't help you there since I have absolutely no idea if there is a Lotus client for Linux and/or ODBC support.
I hope this helps as an alternative...

#!/home/bbq/bin/perl
# Trust no1!

Comment on Re: Accessing a Lotus Notes Database

Replies are listed 'Best First'.
RE: Re: Accessing a Lotus Notes Database by lhoward (Vicar) on May 03, 2000 at 05:12 UTC
If there is a Lotus Notes ODBC client library for Linux, just use DBD::ODBC. If you can't get the ODBC library for Linux but can get it for another platform and still want to run your script on Linux, you should look at DBD::Proxy/DBI::ProxyServer. In a DBD::Proxy setup you would set up a DBI::ProxyServer process running on the box w/ the ODBC client library and it would connect to the Notes database. Then you use DBD::Proxy in your client program (running anywhere) to connect to the DBI::ProxySerer process. I know thats a lot of layers, but it does actually work. I've used this technique to connect a program on a Linux box to an MS-Access DB ... its more stable than you might think.	[reply]
RE: RE: Re: Accessing a Lotus Notes Database by BBQ (Curate) on May 05, 2000 at 07:48 UTC
Talk about n-tier!! Linux Wkst. Windoze Server -------------- ------------------------------ \|Linux\| DBD \| \| DBI \| DBD \| ODBC \| Lotus \| \|Apps \| Proxy\|--->\| Proxy\| ODBC\| Driver\| Client\| -------------- ------------------------------ \| ------------- \| \|Lotus Notes\| <---------------------------- \|Server \| ------------- AIX RS/6000 Is this what you're talking about?	[reply]