Skip site navigation (1) Skip section navigation (2)

Re: WIN Connection -> ODBC -> Linux Slackware

From: John Herreshoff <jkherr(at)centurytel(dot)net>
To: <ebm(at)abs-software(dot)com(dot)au>, pgsql-odbc(at)postgresql(dot)org
Subject: Re: WIN Connection -> ODBC -> Linux Slackware
Date: 2002-03-31 14:32:34
Message-ID: 200203311436.g2VEaFu5001081@mail3.centurytel.net (view raw or flat)
Thread:
Lists: pgsql-odbc
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(at)centurytel(dot)net]
> Sent: Sunday, 31 March 2002 9:06 AM
> To: ebm(at)abs-software(dot)com(dot)au; pgsql-odbc(at)postgresql(dot)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

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-04-01 07:44:22
Subject: Re: 'infinity'::timestamp not translated correctly
Previous:From: DI HasenöhrlDate: 2002-03-31 09:58:37
Subject: Re: ODBCdirect and MsAccess97

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group