Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem to connect to PostgreSQL7.2.3 using UNIXODBC's datamanager

Problem to connect to PostgreSQL7.2.3 using UNIXODBC's datamanager

From
lingjia
Date:
Hi,
 
I have encountered a problem when I tried to use UnixODBC to connect to PostgreSQL7.2.3

Here are my ini files:
*********************************************************
[postgres@sv-ns postgres]$ cat /etc/odbc.ini
[postgre_test]
Description             = postgresql
Driver          = postgresql
Trace           = No
TraceFile               =
Database                = testing
Servername              = sv-ns
UserName                =
Password                =
Port            = 5432
Protocol                = 6.4
ReadOnly                = No
RowVersioning           = No
ShowSystemTables                = No
ShowOidColumn           = No
FakeOidIndex            = No
ConnSettings            =
************************************************************
[postgres@sv-ns postgres]$ cat /etc/odbcinst.ini
[postgresql]
Description             = Driver for postgresql
Driver          = /usr/local/pgsql/lib/libodbcpsql.so
Setup           = /usr/lib/libodbcpsqlS.so
FileUsage               = 1
CPTimeout               =
CPReuse         =
************************************************************
When I run DBManager, it says that:
"Could not connect to the server; could not connect to the remote socket."

The postgresql is running, I am able to browse and issue SQL statements on
the database using psql.  Did I miss sth here?

Thanks in advance!
 
 
Lingjia

Re: Problem to connect to PostgreSQL7.2.3 using UNIXODBC's

From
lingjia
Date:
Hi,
 
Please ignore my previous posting, I searched the web again and changed the following:
 
1) Starting postmaster with -i option
2) uncommeted tcpip_socket=false in /usr/local/pgsql/data/postgresql.conf file and set it to true.
 
And it is working!
 
Thanks anyway!
 
Lingjia
 
 
 
----- Original Message -----
From: lingjia
Sent: Wednesday, December 04, 2002 11:07 AM
Subject: [ODBC] Problem to connect to PostgreSQL7.2.3 using UNIXODBC's datamanager

Hi,
 
I have encountered a problem when I tried to use UnixODBC to connect to PostgreSQL7.2.3

Here are my ini files:
*********************************************************
[postgres@sv-ns postgres]$ cat /etc/odbc.ini
[postgre_test]
Description             = postgresql
Driver          = postgresql
Trace           = No
TraceFile               =
Database                = testing
Servername              = sv-ns
UserName                =
Password                =
Port            = 5432
Protocol                = 6.4
ReadOnly                = No
RowVersioning           = No
ShowSystemTables                = No
ShowOidColumn           = No
FakeOidIndex            = No
ConnSettings            =
************************************************************
[postgres@sv-ns postgres]$ cat /etc/odbcinst.ini
[postgresql]
Description             = Driver for postgresql
Driver          = /usr/local/pgsql/lib/libodbcpsql.so
Setup           = /usr/lib/libodbcpsqlS.so
FileUsage               = 1
CPTimeout               =
CPReuse         =
************************************************************
When I run DBManager, it says that:
"Could not connect to the server; could not connect to the remote socket."

The postgresql is running, I am able to browse and issue SQL statements on
the database using psql.  Did I miss sth here?

Thanks in advance!
 
 
Lingjia