After updating their PCs several of our customers have heavy difficulties to
connect to their postgresql servers. MyLog is showing that libpq returns
'could not translate host name "SERVER" to address: Unknown server error',
see appended log.
NB #1: not every updated PC is affected
NB #2: after several times (10-50) on some PCs DBDriverConnect is successful
NB #3: we never have had this issue since we use postgreSQL (>5 years)
Setup:
Win10 (Update 1803)
32bit DLL : psqlodbc30a.dll v 9.3.4.0
Server: posgresql 9.4
Error exists too with the brandnew psqldobc 10.3.0.0
Any help will be greatly appreciated
regards
bG
-------------------- myLog
[6336-4.817]attribute = 'debug', value = '1'
[6336-4.817]copyAttributes:
DSN='',server='SERVER',dbase='MyDB',user='postgres',passwd='xxxxx',port='3456',onlyread='',conn_settings='(null)')
[6336-4.817]attribute = 'commlog', value = '1'
[6336-4.817]copyAttributes:
DSN='',server='SERVER',dbase='MyDB',user='postgres',passwd='xxxxx',port='3456',onlyread='',conn_settings='(null)')
[6336-4.817]getDSNinfo: DSN= overwrite=0
[6336-4.817]our_connect_string =
'Driver={PostgreSQL};SERVER=SERVER;PORT=3456;DATABASE=MyDB;UID=postgres;PWD=MyDB;UpdatableCursors=1;usedeclarefetch=1;UseServerSidePrepare=1;MaxVarcharSize=4000;debug=1;commlog=1'
[6336-4.817]attribute = 'Driver', value = '{PostgreSQL}'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'SERVER', value = 'SERVER'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'PORT', value = '3456'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'DATABASE', value = 'MyDB'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'UID', value = 'postgres'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'PWD', value = 'MyDB'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'UpdatableCursors', value = '1'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=0;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'usedeclarefetch', value = '1'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'UseServerSidePrepare', value = '1'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=255;B1=8190;B2=0;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'MaxVarcharSize', value = '4000'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=4000;B1=8190;B2=0;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'debug', value = '1'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=4000;B1=8190;B2=1;B3=0;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.817]attribute
= 'commlog', value = '1'
[6336-4.817]copyCommonAttributes:
A7=100;A9=0;B0=4000;B1=8190;B2=1;B3=1;B6=1;B7=1;B8=0;B9=1;C0=0;C2=dd_[6336-4.832]calling
getDSNdefaults
[6336-4.832]CC_connect: entering...
[6336-4.832]sslmode=disable
[6336-4.832]LIBPQ_CC_connect: entering...
[6336-4.832]Driver Version='09.05.0300,Jun 17 2016' linking 1800 dynamic
Multithread library
[6336-4.832]LIBPQ_CC_connect: DSN = '', server = 'SERVER', port = '3456',
database = 'MyDB', username = 'postgres', password='xxxxx'
[6336-4.832]connecting to the database using SERVER as the server
[6336-4.832]CC_error_statements: self=0122A300
[6336-4.832]CONN ERROR: func=LIBPQ_connect, desc='', errnum=101,
errmsg='could not translate host name "SERVER" to address: Unknown server
error
'
[6336-4.848]Could not establish connection to the database; LIBPQ returned
-> could not translate host name "SERVER" to address: Unknown server error
[6336-4.848]LIBPQ_connect: retuning 0
[6336-4.848]CONN ERROR: func=PGAPI_DriverConnect, desc='Error from
CC_Connect', errnum=101, errmsg='could not translate host name "SERVER" to
address: Unknown server error
'
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-odbc-f2186591.html