Postgres Pro
Downloads
Home   >   mailing lists

Thread: Can't connect by ODBC

Can't connect by ODBC

From
Andreas Schlegel
Date:
Hi,

I get the following error message to connect on Postgres 7.0 with ODBC:
"Could not connect to server; Could not connect to remote socket.
(#101)"

I have no problems to work on psql with telnet from a win client.


My configuration:

pg_hba.conf:
host  all  192.168.90.0  255.255.255.0  trust

/etc/init.d/postgresql:
OPTIONS=${POSTGRES_OPTIONS:-"-i"}

Server: Postgres 7.0 and  Suse 7.2
Client: ODBC 7.01.00.10 and W2K

Has anybody any ideas on what might have changed?

Greetings,
Andreas


My log:
Global Options: Version='07.01.0010', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
                disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
                text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
                extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=101, errmsg='Could not connect to the server'
            ------------------------------------------------------------
            henv=153421936, conn=153383568, status=0, num_stmts=16
            sock=153421888, stmts=153421808, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=-1, reverse=0, errornumber=4, errormsg='Could not
connect to remote socket.'
            buffer_in=153394488, buffer_out=153398592
            buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0

Re: Can't connect by ODBC

From
"Johann Zuschlag"
Date:
On Sat, 13 Apr 2002 16:23:01 +0200, Andreas Schlegel wrote:

>My configuration:
>
>pg_hba.conf:
>host  all  192.168.90.0  255.255.255.0  trust
>
>/etc/init.d/postgresql:
>OPTIONS=${POSTGRES_OPTIONS:-"-i"}
>
>Server: Postgres 7.0 and  Suse 7.2
>Client: ODBC 7.01.00.10 and W2K

Did you create a postgreSQL user?
Did you supply a valid user and password in the setup?

Try latest Version 7.01.00.11
I would anyway prefer PostgreSQL 7.2.1.

regards


Johann Zuschlag
zuschlag2@online.de

Re: Can't connect by ODBC

From
Andreas Schlegel
Date:
Johann Zuschlag wrote:
>
> On Sat, 13 Apr 2002 16:23:01 +0200, Andreas Schlegel wrote:
>
> Did you create a postgreSQL user?
Yes, I have some.

> Did you supply a valid user and password in the setup?
I think so ;-)

>
> Try latest Version 7.01.00.11
I couldn't find it. The download dir
(http://odbc.postgresql.org/ftpsite/odbc/versions/msi/) has as latest
version 7.01.00.10

Thanks for your answer,
Andreas

Re: Can't connect by ODBC

From
Dave Page
Date:

> -----Original Message-----
> From: Andreas Schlegel [mailto:schlegel@software.b.uunet.de]
> Sent: 13 April 2002 19:15
> To: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Can't connect by ODBC
>
>
> Johann Zuschlag wrote:
> >
> > On Sat, 13 Apr 2002 16:23:01 +0200, Andreas Schlegel wrote:
> >
> > Did you create a postgreSQL user?
> Yes, I have some.
>
> > Did you supply a valid user and password in the setup?
> I think so ;-)
>
> >
> > Try latest Version 7.01.00.11
> I couldn't find it. The download dir
> (http://odbc.postgresql.org/ftpsite/odbc/versions/msi/) has
> as latest version 7.01.00.10

That is the latest release. 07.01.0011 is development code.

Regards, Dave.