Error connecting via ODBC - 'Could not connect to remote socket'

From: "James Pitman" <jrpitman(at)worldnet(dot)att(dot)net>
To: <pgsql-ports(at)postgresql(dot)org>
Subject: Error connecting via ODBC - 'Could not connect to remote socket'
Date: 2000-01-04 04:06:09
Message-ID: 001501bf5669$118a62e0$a1a94b0c@continuumlogic.continuumlogic
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-ports

Could you offer any assistance as to why I am receiving this error? I am using postgresql 6.5.1 on Linux Mandrake 6.1 and I am trying to connect via ODBC from a Windows 98 box using Access 97. I have the startup script for postmaster forcing port 5432 with the following options:

-S -D/var/lib/plsql -i -s -p5432

I would appreciate nay assistance you could provide. I have been struggling with this error for some time.

Thanks, James Pitman

conn=57870460, SQLDriverConnect( in)='DSN=test2;', fDriverCompletion=1

DSN info: DSN='test2',server='test_server',port='5432',dbase='test1',user='postgres',passwd='test'

readonly='1',protocol='6.4',showoid='0',fakeoidindex='0',showsystable='0'

conn_settings=''

translation_dll='',translation_option=''

Global Options: Version='06.40.0006', fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190

disable_optimizer=1, ksqo=1, unique_index=0, use_declarefetch=0

text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1

extra_systable_prefixes='dd_;', conn_settings=''

CONN ERROR: func=SQLDriverConnect, desc='Error from CC_Connect', errnum=101, errmsg='Could not connect to the server'

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

henv=58916996, conn=57870460, status=0, num_stmts=16

sock=58917012, stmts=58917052, lobj_type=-999

---------------- Socket Info -------------------------------

socket=-1, reverse=0, errornumber=4, errormsg='Could not connect to remote socket.'

buffer_in=57876788, buffer_out=57880888

buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0

Browse pgsql-ports by date

  From Date Subject
Next Message Kevin Lo 2000-01-04 05:01:08 Re: [GENERAL] Announce: PostgreSQL-6.5.3 binaries available forWindows NT
Previous Message Kevin Lo 2000-01-04 03:52:40 Re: [INTERFACES] Announce: PostgreSQL-6.5.3 binaries available forWindows NT