[ psqlodbc-Bugs-1000490 ] cannot connect

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=10004 90&group_id=1000125

Category: None
Group: None
>Status: Deleted
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 Linux 3.3.3-2.1)

Regards,
Alfred Tuinman

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

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

Message:
This is not a bug. I delete it.

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

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 port 5432? 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=10004 90&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match