[ psqlodbc-Bugs-1000490 ] cannot connect - Mailing list pgsql-odbc

From
Subject [ psqlodbc-Bugs-1000490 ] cannot connect
Date
Msg-id 20051217230345.082DD1125042@pgfoundry.org
Whole thread Raw
List pgsql-odbc
Bugs item #1000490, was opened at 2005-12-17 23:54
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000490&group_id=1000125

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

Initial Comment:
Hi,

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
Linux3.3.3-2.1) 

Regards,
Alfred Tuinman

----------------------------------------------------------------------

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

Message:
There is proper place in pgsql-odbc@postgresql.org. 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
port5432? Doesn't you server require SSL which isn't supported with psqlodbc 07.03.0200? 

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000490&group_id=1000125

pgsql-odbc by date:

Previous
From: Ludek Finstrle
Date:
Subject: Re: Patch for 1000478 Cannot create DNS using odbcconf.exe utility in Windows
Next
From:
Date:
Subject: [ psqlodbc-Bugs-1000488 ] Dollar quoting and '?' in string cause unexpected error.