Hi

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