It works for me. Open the postgresql.conf file. I'd guess that it is remmed
out with a #, and the line says tcpic_socket=false. Un-rem it, and set
tcpic_socket=true. You should be off and running.
John.
On Sunday 31 March 2002 02:29 am, Eric March wrote:
> postgresql.conf file has a line
> #tcpip_socket = false
> Am I right in assuming this enables tcpip
>
>
> -----Original Message-----
> From: John Herreshoff [mailto:jkherr@centurytel.net]
> Sent: Sunday, 31 March 2002 9:06 AM
> To: ebm@abs-software.com.au; pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] WIN Connection -> ODBC -> Linux Slackware
>
>
> Do you have a postgresql.conf file in the same directory? You need to
> enable
> tcpip. You can do this in postgresql.conf.
>
> HTH.
>
> John.
>
> On Saturday 30 March 2002 05:49 pm, Eric March wrote:
> > In Win98 I go to
> >
> > settings -> ODBC Data Sources (32 bit) -> ABS (Driver Postgresql) ->
> > configure
> >
> > There I get a box headed "PostgreSQL Driver Setup"
> > which I have filled in as folows:
> >
> >
> > Data Source: ABS
> > Database: abs
> > Server: 192.168.1.1
> > User Name: postgres
> > Description: Database
> > Port: 5432
> > Password: ********
> >
> > The Server is Linux Postgres compiled Feb 25
> > In the directory /usr/local/pgsql/data the file
> >
> > pg_hba.conf has following settings
> >
> > # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
> > AUTH_ARGUMENT
> >
> > local all trust
> > host all 127.0.0.1 255.255.255.255 trust
> > host all 192.168.1.0 255.255.255.0 trust
> >
> > psql works for user postgress (2 s's) in Unix.
> > I am logged onto Win98 as user ejm
> >
> > From XL I try to connect to external data abs and get an error message
> >
> > Microsoft query
> > Could not connect to server;
> > Could not connect to remote socket.
> >
> > Help please!
> >
> >
> > Eric J March
> > PO Box 475
> > Hahndorf SA 5245
> > Australia
> >
> >
> > Phone 618 8389 2500
> > Fax 618 8389 2488
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> > http://www.postgresql.org/users-lounge/docs/faq.html