Thread: Remote connection through ODBC
Dear all
I am a newbie using PostgreSQL, for instance through ODBC. I have troubles with the remote connection through ODBC. I have a PostgreSQL 9.1 instance on an Ubuntu 13.04, a client on a Centos 6.4.
ODBC driver on the CentOs machine is the standard one shipped in the CentOS repo, version 08.04.0200.
I have no problem to connect locally to the PostgreSQL from the Ubuntu machine. However, when I try an isql query from the Centos client, i get
[ISQL]ERROR: Could not SQLConnect.
Note that the file postgresql.conf contains a listen_adresses='*', and pg_hba.conf contains the line
host all all 0.0.0.0/0 md5
On the other hand, I have no problem to connect through pgadmin3 from the CentOS machine. As well with the psql commant : it works.
At the end, I am interested in querying the database from a C code : of course it does not work
File obc.ini contains correct credentials (and a connection to a MySQL server works)
Any help would be much appreciated !
Benjamin.
I am a newbie using PostgreSQL, for instance through ODBC. I have troubles with the remote connection through ODBC. I have a PostgreSQL 9.1 instance on an Ubuntu 13.04, a client on a Centos 6.4.
ODBC driver on the CentOs machine is the standard one shipped in the CentOS repo, version 08.04.0200.
I have no problem to connect locally to the PostgreSQL from the Ubuntu machine. However, when I try an isql query from the Centos client, i get
[ISQL]ERROR: Could not SQLConnect.
Note that the file postgresql.conf contains a listen_adresses='*', and pg_hba.conf contains the line
host all all 0.0.0.0/0 md5
On the other hand, I have no problem to connect through pgadmin3 from the CentOS machine. As well with the psql commant : it works.
At the end, I am interested in querying the database from a C code : of course it does not work
File obc.ini contains correct credentials (and a connection to a MySQL server works)
Any help would be much appreciated !
Benjamin.
Hi, (2013/07/10 23:47), HAAS Benjamin wrote: > Dear all > > I am a newbie using PostgreSQL, for instance through ODBC. I have > troubles with the remote connection through ODBC. I have a PostgreSQL > 9.1 instance on an Ubuntu 13.04, a client on a Centos 6.4. > > ODBC driver on the CentOs machine is the standard one shipped in the > CentOS repo, version 08.04.0200. > > I have no problem to connect locally to the PostgreSQL from the Ubuntu > machine. However, when I try an isql query from the Centos client, i get > [ISQL]ERROR: Could not SQLConnect. > > Note that the file postgresql.conf contains a listen_adresses='*', and > pg_hba.conf contains the line > host all all 0.0.0.0/0 md5 > > On the other hand, I have no problem to connect through pgadmin3 from > the CentOS machine. As well with the psql commant : it works. > > At the end, I am interested in querying the database from a C code : of > course it does not work > > File obc.ini contains correct credentials (and a connection to a MySQL > server works) Could you please show us your odbc.ini? regards, Hiroshi Inouw
Hi, Problem solved late yesterday, the problem was indeed in odbc.ini. The keyword for the server name, user name and the portare not the same as for MySQL. I was not aware of that. Sorry for polluting your mail boxes with such a trivial problem! Best. -----Message d'origine----- De : Inoue, Hiroshi [mailto:inoue@tpf.co.jp] Envoyé : jeudi 11 juillet 2013 01:40 À : HAAS Benjamin Cc : pgsql-odbc@postgresql.org Objet : Re: [ODBC] Remote connection through ODBC Hi, (2013/07/10 23:47), HAAS Benjamin wrote: > Dear all > > I am a newbie using PostgreSQL, for instance through ODBC. I have > troubles with the remote connection through ODBC. I have a PostgreSQL > 9.1 instance on an Ubuntu 13.04, a client on a Centos 6.4. > > ODBC driver on the CentOs machine is the standard one shipped in the > CentOS repo, version 08.04.0200. > > I have no problem to connect locally to the PostgreSQL from the Ubuntu > machine. However, when I try an isql query from the Centos client, i > get > [ISQL]ERROR: Could not SQLConnect. > > Note that the file postgresql.conf contains a listen_adresses='*', and > pg_hba.conf contains the line host all all 0.0.0.0/0 md5 > > On the other hand, I have no problem to connect through pgadmin3 from > the CentOS machine. As well with the psql commant : it works. > > At the end, I am interested in querying the database from a C code : > of course it does not work > > File obc.ini contains correct credentials (and a connection to a MySQL > server works) Could you please show us your odbc.ini? regards, Hiroshi Inouw