Thread: CONN ERROR: func=original_CC_connect, desc='"', errnum=210, errmsg=''"
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
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