Forum OpenACS Q&A: Re: ODBC-connection to Postgres database
$ 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 :)
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.