- 论坛徽章:
- 0
|
odbc for postgresql drive 已装好,但是用odbc 连接数据库时,发现些问题,请求支援!!
提示此错误信息,No connection could be made because the target machine actively refused it.!!
查看log,
[0.000]Driver Version='08.03.0100,200801220001' linking 1400 static Multithread library
[0.001]Global Options: fetch=100, socket=4096, unknown_sizes=0, max_varchar_size=255, max_longvarchar_size=8190
[0.002] disable_optimizer=1, ksqo=1, unique_index=1, use_declarefetch=0
[0.003] text_as_longvarchar=1, unknowns_as_longvarchar=0, bools_as_char=1 NAMEDATALEN=64
[0.004] extra_systable_prefixes='dd_;', conn_settings='' conn_encoding=''
[0.970]CONN ERROR: func=original_CC_connect, desc='', errnum=101, errmsg='Could not connect to the server'
[0.971] ------------------------------------------------------------
[0.971] henv=00FE3F50, conn=00FE3F80, status=0, num_stmts=16
[0.972] sock=00FE6AD8, stmts=00FE8BB8, lobj_type=-999
[0.973] ---------------- Socket Info -------------------------------
[0.973] socket=-1, reverse=0, errornumber=4, errormsg='No connection could be made because the target machine actively refused it.
[192.168.1.208:5432]'
[0.975] buffer_in=16673704, buffer_out=16677808
[0.975] buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0
socket 是没有建立好,但是服务远程服务器是在监听5432 端口,而且pg_hba.conf 文件我也进行了修改,添加了
host all JSFER 192.168.1.0/24 trust
此问题请教支援!!! 谢谢 |
|