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
3) pg_hba.conf needs a line appended to allow your client's IP address
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.
Dave Huttleston Jr.
On Mon, 16 Oct 2000 06:16:45 -0400 (EDT), you wrote:
> 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.
> FREE! The World's Best Email Address @email.com
> Reserve your name now at http://www.email.com
In response to
pgsql-admin by date
|Next:||From: Bruce Momjian||Date: 2000-10-16 15:53:21|
|Subject: Re: [7.0.2] rotating log files ...|
|Previous:||From: Kisala Muhavi||Date: 2000-10-16 10:16:45|
|Subject: Database connectivity|