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

[ psqlodbc-Bugs-1000490 ] cannot connect

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000490 ] cannot connect
Date: 2005-12-23 09:38:01
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Bugs item #1000490, was opened at 2005-12-17 23:54
You can respond by visiting:

Category: None
Group: None
>Status: Deleted
Resolution: None
Priority: 3
Submitted By: alfred tuinman (jadoo)
Assigned to: Nobody (None)
Summary: cannot connect

Initial Comment:

I cannot find the proper place to query what is wrong with my odbc setting. I'm pretty frstrated as to why it doesn't work. Anbody has any ideas?

conn = 50869768, PGAPI_Connect(DSN='jadoo_dsn', UID='admin', PWD='xxxxx')
Global Options: Version='07.03.0200', 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=0 NAMEDATALEN=64
                extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
CONN ERROR: func=PGAPI_Connect, desc='Error on CC_connect', errnum=101, errmsg='Could not connect to the server'
            henv=50869712, conn=50869768, status=0, num_stmts=16
            sock=50880768, stmts=50889048, lobj_type=-999
            ---------------- Socket Info -------------------------------
            socket=-1, reverse=0, errornumber=4, errormsg='Could not connect to remote socket.'
            buffer_in=50880840, buffer_out=50884944
            buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0

I use PostgreSQL 7.4.2 on i386-redhat-linux-gnu, compiled by GCC i386-redhat-linux-gcc (GCC) 3.3.3 20040216 (Red Hat Linux 3.3.3-2.1)

Alfred Tuinman


>Comment By: Ludek Finstrle (luf)
Date: 2005-12-23 10:38

This is not a bug. I delete it.


Comment By: Ludek Finstrle (luf)
Date: 2005-12-18 00:03

There is proper place in pgsql-odbc(at)postgresql(dot)org(dot) Please move next communication there.

Could you connect server via psql? Are you trying connect to remote or local host? Does your postgresql listening on port 5432? Doesn't you server require SSL which isn't supported with psqlodbc 07.03.0200?


You can respond by visiting:

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2005-12-23 09:52:03
Subject: Re: Values in the select
Previous:From: noreplyDate: 2005-12-23 09:35:49
Subject: [ psqlodbc-Bugs-1000498 ] rollback to savepoint in case of error

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