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

Collapse
3: Re: ODBC-connection to Postgres database (response to 1)
Posted by Lars Pind on 01/20/03 01:40 PM
Yeah, I saw that. And my RH Linux 7.2 already has the following ODBC-related RPMs installed:

$ rpm -qa|grep odbc
postgresql-odbc-7.1.3-2
libodbc++-0.2.2pre4-12
libodbc++-devel-0.2.2pre4-12
php-odbc-4.0.6-15

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 :)

Thanks,
/Lars

Collapse
7: Re: ODBC-connection to Postgres database (response to 3)
Posted by Roberto Mello on 01/20/03 05:13 PM
This document should help on the PostgreSQL setup side: "Installation and configuration of PostgreSQL & ODBC on Redhat Linux"  http://gborg.postgresql.org/project/psqlodbc/genpage.php?howto-redhat

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.

-Roberto