Salve a tutti. Desidero sapere se qualcuno ha già provato a connettere (link table) un database Access su serverWin ad un database postgresSQL su server Linux : il tutto via ODBC.

Grazie in anticipo per eventuali suggerimenti.

Io non riesco a connettermi, ma credo che il problema risieda lato server-Postgre, e quindi chiederò all'amministratore dello stesso.

Comunque volevo intanto sapere se poi modificare i records si Postgres da Access?

Grazie in anticipo

ODBC -- call Failed
could not connect to server
could not connect to remote socket (#101)

......su access, mentre il file log di PG :

CONN ERROR: func=PGAPI_GetConnectOption, desc='fOption=30002', errnum=205, errmsg='Unknown connect option (Get)'
------------------------------------------------------------
henv=140582800, conn=140588896, status=0, num_stmts=16
sock=140582856, stmts=140582928, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=0, errormsg='(NULL)'
buffer_in=140599896, buffer_out=140604000
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
conn=140588896, PGAPI_DriverConnect( in)='DSN=PostgreSQL30;', fDriverCompletion=1
DSN info: DSN='PostgreSQL30',server='213.212.000.000',port='5432',dbase='test',user='xxxxx',passwd='xxxxx'
onlyread='0',protocol='6.4',showoid='1',fakeoidindex='1',showsystable='0'
conn_settings='',conn_encoding='OTHER'
translation_dll='',translation_option=''
Global Options: Version='07.03.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=1
text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
extra_systable_prefixes='dd_;', conn_settings='' conn_encoding='OTHER'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect', errnum=101, errmsg='Could not connect to the server'
------------------------------------------------------------
henv=140582800, conn=140588896, status=0, num_stmts=16
sock=140582856, stmts=140582928, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=4, errormsg='Could not connect to remote socket.'
buffer_in=140599896, buffer_out=140604000
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0



P.S.
A PROPOSITO, le tabelle le hai solo importate o Linkate ?

Verifico con l'amministratore e riferisco...