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-17 23:03:45
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
Bugs item #1000490, was opened at 2005-12-17 23:54
You can respond by visiting:

Category: None
Group: None
Status: Open
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-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: noreplyDate: 2005-12-17 23:11:57
Subject: [ psqlodbc-Bugs-1000488 ] Dollar quoting and '?' in string cause unexpected error.
Previous:From: Ludek FinstrleDate: 2005-12-17 22:56:20
Subject: Re: Patch for 1000478 Cannot create DNS using odbcconf.exe utility in Windows

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