CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''" - Mailing list pgadmin-support

From Mike Knell
Subject CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"
Date
Msg-id BAY125-F2806A439248FB42FB1D2DCD5EB0@phx.gbl
Whole thread Raw
Responses Re: CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"
List pgadmin-support
Hi

(First apologies for second posting but I did not have subject on previous)

I have successfully set up a linked server to access a Postgres database via 
SQL Server on my XP machine.

I have tried to do the same from a Windows 2003 server running SQL server 
2000 but it does not connect.

When I click Test in the PostgreSQL ODBC Driver Setup it does not say 
�Connection Successful� like it does on my machine, but instead it does not 
say anything at all. A popup message box appears with no message.

- Postgres ODBC Ansi driver, latest version 8.02.02.00.
- Postgres 8.1 ?
- Windows Server 2003 (Service Pack 1 NOT installed yet)

Any ideas please? Like I say I have no problem connecting from my machine.

Logs attached below

THANKS, Mike


PSqlODBC Log

DSN info: 
DSN='PostgreSQL30',server=xxx.xxx.x.xxx',port='5432',dbase='bxxx',user='postgres',passwd='xxxxx'        
onlyread='0',protocol='7.4',showoid='0',fakeoidindex='0',showsystable='0'        conn_settings='',conn_encoding='OTHER'
      translation_dll='',translation_option=''
 
Global Options: Version='08.02.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=1 NAMEDATALEN=64              extra_systable_prefixes='dd_;', conn_settings='' 
conn_encoding='OTHER'
ERROR from backend during original_CC_connect: ''
CONN ERROR: func=original_CC_connect, desc='', errnum=210, errmsg=''
------------------------------------------------------------         henv=00000000, conn=007F3A80, status=0,
num_stmts=16         sock=007F65C8, stmts=007F86A0, lobj_type=-999          ---------------- Socket Info
-------------------------------         socket=120, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=8349328,buffer_out=8353432          buffer_filled_in=136, buffer_filled_out=0, buffer_read_in=2
 
ERROR from backend during authentication: ''



MyLog

[2888-0.000]globals.extra_systable_prefixes = 'dd_;'
[2888-0.000]exe name=odbcad32 plaformId=2
[2888-0.000]aszKey='DSN', value='PostgreSQL30'
[2888-0.000]copyAttributes: 

DSN='PostgreSQL30',server='',dbase='',user='',passwd='xxxxx',port='',onlyread='',protocol='',conn_settings='',disallow_premature=-1)
[2888-0.015]getDSNinfo: DSN=PostgreSQL30 overwrite=0
[2888-0.015]rollback_on_error=1
[2888-0.015]force_abbrev=0 bde=0 cvt_null_date=0
[2888-0.015]globals.extra_systable_prefixes = 'dd_;'
[2888-0.015]calling getDSNdefaults
[2888-0.015]checking libpq library
[2888-0.125]psqlodbc path based libpq loaded module=63100000
[2888-0.125]hmodule=63100000
[2888-0.125]libpq_exist=1
[2888-1.375]CC_connect: entering...
[2888-1.375]sslmode=disable
[2888-1.375]original_CC_connect: entering...
[2888-1.375]original_CC_connect: DSN = 'PostgreSQL30', server = 
xxx.xxx.x.xxx', port = '5432', database = 'bxxx', username = 'postgres', 
password='xxxxx'
[2888-1.375]connecting to the server socket...
[2888-1.406](0)(null) ERRNO=0
[2888-1.406]connection to the server socket succeeded.
[2888-1.406]sizeof startup packet = 77
[2888-1.406]sent the authentication block successfully.
[2888-1.406]gonna do authentication
[2888-1.406]read -1, global_socket_buffersize=4096
[2888-1.406]Lasterror=10035
[2888-1.421]read 136, global_socket_buffersize=4096
[2888-1.421]auth got 'E'
[2888-1.421]original_CC_connect: 'E' -
[2888-1.421]CC_error_statements: self=007F3A80
[2888-1.421]CONN ERROR: func=original_CC_connect, desc='', errnum=210, 
errmsg=''
[2888-1.421]enter CC_get_error
[2888-1.421]enter CC_create_errormsg
[2888-1.421]msg = ''
[2888-1.421]exit CC_create_errormsg
[2888-1.421]exit CC_get_error
[2888-2.359]enter CC_Destructor, self=007F3A80
[2888-2.359]in CC_Cleanup, self=007F3A80
[2888-2.359]after CC_abort
[2888-2.359]SOCK_Destructor
[2888-2.359]after SOCK destructor
[2888-2.359]exit CC_Cleanup
[2888-2.359]after CC_Cleanup
[2888-2.359]after free statement holders
[2888-2.359]exit CC_Destructor
[2888-5.515]DETACHING PROCESS

_________________________________________________________________
Windows Live� Messenger has arrived. Click here to download it for free! 
http://imagine-msn.com/messenger/launch80/?locale=en-gb



pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Results from testing RC2, rev: 5607:5627M
Next
From: "Milen A. Radev"
Date:
Subject: Re: CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"