Re: Database connectivity

Hey Kisala,

  To get a windows client and a postgres linix server talking you need
several things done on the server and the client.

On the server:

1) pg 7.02 needs to have been compiled with ODBC support on
2) pg 7.02 needs to be running with the -i option to allow
    remote connections
3) pg_hba.conf needs a line appended to allow your client's IP address
    For example:
host    all    10.0.0.2    255.255.255.0    trust
(change 10.0.0.2 and 255.255.255.0 to match the client's IP and netmask
 you wish to connect to postgres on your server.)

On each client:
1) install the Windows ODBC driver on your client
2) create a ODBC data source using ODBC32 on the client.  Make sure
  you turn *ON* the declare/fetch option when setting the properties.
3) Test connection using MS Access.  For example, create an ODBC link
  and try a query.

  I think you will get better help with any problems using Access initially.
There is not much talk of VB on these lists, but lots of Postgres-via-Access.

Good Luck,
    Dave Huttleston Jr.

On Mon, 16 Oct 2000 06:16:45 -0400 (EDT), you wrote:
> hi,
> I have postgres installed on my linux apache server. Im using Visual basic 6
> and MS Access as my front-end tools. Im unnable to connect to postgresql
> database, despite that ive the latest ODBC drivers of postgresql installed
> on my windows machine. Please advice me on how to connect to postgres from
> windows environment. Im doing all this on LAN.
> Thanks.
> bonny
>
>
> -----------------------------------------------
> FREE! The World's Best Email Address @email.com
> Reserve your name now at http://www.email.com
>
>