I got a problem in connecting a BASE Client (OpenOffice DB Client) to a remote, SSL-secured PostgreSQL server. Both, client and server, running FreeBSD 7.0, but this does only matter for the OO client side. With OO under Windows it is either with ODBC or JDBC possible to connect via SSL to the DB server, but this is not for OO under FreeBSD using JDBC/ODBC as recently compiled from the ports.

I searched the net and found that because postges-odbc is compiled against libpg.so on FreeBSD/UNIX and SSL connectivity is therein, it should be up to the ODBC driver how to connect , but I did not find any explanation what to switch on or of in odbc.ini.

Even with JDBC (postgres-jdbc), where SSL should be a standard with JDK 1.5, I can not find any information about a knob or even any help on that so I guess the specific driver, either JDBC or ODBC should be capable of negotiating the connection type.

This works without problems with Windows clients running OO or M$-Office using JDBC or ODBC from www.potgresql.org.

Can anybody help or give a hint?

freebsd-questions@freebsd.org mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to