Thread: CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"

CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"

From
"Mike Knell"
Date:
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



Re: CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"

From
"Milen A. Radev"
Date:
Mike Knell написа:
> 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
> 
> 
[...]


Mike,

This is the support mail list for pgAdmin - a management and
administration tool for PostgreSQL. It uses the native libraries to
connect to the server. That's why this list is not the appropriate one
for reporting problems using the ODBC drivers.
Please have a look at the archives of the PGSQL's ODBC mail list here -
http://archives.postgresql.org/pgsql-odbc/.


-- 
Milen A. Radev



Re: CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"

From
"Mike Knell"
Date:
Hi Milen

Oops , wrong address. Thanks!


>From: "Milen A. Radev" <milen@radev.net>
>To: Mike Knell <mike-knell@hotmail.co.uk>
>Subject: Re: CONN ERROR: func=original_CC_connect, desc='"', errnum=210, 
>errmsg=''"
>Date: Tue, 14 Nov 2006 16:15:05 +0200
>
>Mike Knell написа:
> > 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
> >
> >
>[...]
>
>
>Mike,
>
>This is the support mail list for pgAdmin - a management and
>administration tool for PostgreSQL. It uses the native libraries to
>connect to the server. That's why this list is not the appropriate one
>for reporting problems using the ODBC drivers.
>Please have a look at the archives of the PGSQL's ODBC mail list here -
>http://archives.postgresql.org/pgsql-odbc/.
>
>
>--
>Milen A. Radev

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