Hi, I'm trying to connect postgresql 8.1 to domino server/lotus notes
6.01 (no results at the moment!) installed on a linux server.
Do you know if is it possible? How?
Thanks in advance

Gabriele <gafiljob1 (AT) jumpy (DOT) it> wrote:
Can you specify 'connect'? Which protocol, e.g.?

By 'postgresql 8.1', do you mean libpq.so or some other client interface
or the PostgreSQL server?

Maybe it also helps if you specify what you hope to achieve with this
connection.

Yours,
Laurenz Albe

I'm sorry for poor informations! At the moment, I have a db sample on
postresql server 8.1 and I'd like connecting it to Lotus Notes Client
(6.01) through Domino Server (6.01).
I'd like reading and writing data on postgresql db sample using an
application db on Lotus Notes Client.
Domino server 6.01 and Postgresql Server 8.01 are on the same pc server
that has Linux (kernel 2.2) as operative system.
Thanks in advance
(sorry for my English!)


Laurenz Albe ha scritto:

gjob <gafiljob1 (AT) jumpy (DOT) it> wrote:
Ok, so you want to access a PostgreSQL database from either a Lotus Notes
Server or a Lotus Notes Client (it does not become clear to me which of
the two you actually mean).

I can only give you pointers for the PostgreSQL side of things, as I have
no idea how communicative Lotus Notes is.

PostgreSQL normally uses a proprietary protocol for client-server
communication, which goes by the name of 'line protocol'. It is probably
impossible or not feasible to get Lotus Notes to talk in this foreign
language.

Standard interfaces that come to my mind are:
- Perl with DBI and DBD::Pg
- unixODBC with the PostgreSQL-Driver
- Java via JDBC
- the Python PostgreSQL client
- The tcl PostgreSQL client

Maybe other people have more suggestions.
Some of these interfaces are fairly standardized (e.g. JDBC).
Maybe you can get Lotus Notes to talk one of these languages!

Yours,
Laurenz Albe