Thread: Postgres ODBC

Postgres ODBC

From
rob5@megared.net.mx
Date:
Hello, 
I've never used ODBC connections and I need to do one for a system 
I'm programing. 
I would like to know if someone could tell me step by step how to 
connect using Delphi 4.0 or MS Access to a remote postgres database 
that is runing on a Linux Red hat 7.0 server.

Both Linux server and the PC are using the same LAN.

I would really appreciate if you could let me know what drivers I 
need and how could I this work.

Thanks 
Roberto
Renteria

--------------------------------------------------------------
Este mensaje fue enviado mediante Web E-mail de MegaRed
Internet por Cable <<<<< >>>>> http://www.megared.net.mx




Re: Postgres ODBC

From
Date:
> Hello, 
> I've never used ODBC connections and I need to do one for a system 
> I'm programing. 
> I would like to know if someone could tell me step by step how to 
> connect using Delphi 4.0 or MS Access to a remote postgres database 
> that is runing on a Linux Red hat 7.0 server.
> 
> Both Linux server and the PC are using the same LAN.
> 
> I would really appreciate if you could let me know what drivers I 
> need and how could I this work.

We use C++Builder with PostgreSQL. It works. Here's the main steps.

1. You have to set up a working PostgreSQL server accepting IP connections from
your local net.

2. Install PostgreSQL ODBC driver into your Windows machines. Search this list
archive for the driver location.

3. Make an ODBC DSN in the Windows Control panel with your new PostgreSQL ODBC
driver. You have to spec. the server machine, the dtabase name in the SQL server
and so. Check the advanced options for ReadOnly settings! See the archive...

4. Make a BDE "Database" for that ODBC DSN. If you have Delphi installed you
have to find BDE Administrator in the control panel to do this.

5. In Delphi try to use the created BDE "Database" as Borland says.

If you have questions doing this, ask me. If you don't like BDE, use another
tools. See archive.

There is a new PostgreSQL list: <pgsql-odbc@postgresql.org> Please use that
for new ODBC related questions.

-- 
Tibor Laszlo
ltibor@mail.tiszanet.hu