Forum OpenACS Q&A: Re: ODBC-connection to Postgres database

Posted by Lars Pind on
Yeah, I saw that. And my RH Linux 7.2 already has the following ODBC-related RPMs installed:

$ rpm -qa|grep odbc

Now, how do I get PG to listen for ODBC-connections? Is there a standard ports which ODBC uses?

How can I test that the PG ODBC interface is up?

How can I configure Windows/Office to make ODBC connections to my PG running on my server? Do I need a special Windows PG ODBC client driver to do that?

In short, I don't have a clue how this works, so I'm hoping someone could clue me in :)


Posted by Roberto Mello on
This document should help on the PostgreSQL setup side: "Installation and configuration of PostgreSQL & ODBC on Redhat Linux"

It even talks about how to setup PG so LOBs work from odbc.

I know I've done this in the past, when porting an MS Access app to PostgreSQL, but can't remember all the steps.