Thread: WIN Connection -> ODBC -> Linux Slackware
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
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
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