Thread: Interfacing with MS Access

Interfacing with MS Access

From
"Sergio O. Garza"
Date:
I have installed postgresql-6.4.2 with ODBC support on my redhat linux
server but most people around here use MS Access as their database. I
have installed libiodbc-2.50  and downloaded the psqlODBC driver for my
windows machines.
There is now an odbc.ini and odbcinst.ini in my /etc directory.

How do I make this connection?
Which of these two files do I use?

Sergio O. Garza


Re: [INTERFACES] Interfacing with MS Access

From
Sergio
Date:
"Sergio O. Garza" <kssog00@sunlib.tamuk.edu> el día Thu, 25 Mar 1999
09:28:21 -0600, escribió:

>I have installed postgresql-6.4.2 with ODBC support on my redhat linux
>server but most people around here use MS Access as their database. I
>have installed libiodbc-2.50  and downloaded the psqlODBC driver for my
>windows machines.
>There is now an odbc.ini and odbcinst.ini in my /etc directory.
>
>How do I make this connection?
>Which of these two files do I use?

you don't need Odbc in the linux box, only postgresql-clients

in the windows machine you must install the odbc driver, setup
it (control-panel->odbc) and voilé.

Also make sure Postgres is listening network connections (-i parameter)
and that your win machine have rights to access Postgres (pg_hba.conf
in the linux box)

Sergio K. (not the original poster :)