psqlodbc driver issue with Win10 Update 1803

From: BGoebel <b(dot)goebel(at)prisma-computer(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: psqlodbc driver issue with Win10 Update 1803
Date: 2018-06-04 14:38:22
Message-ID: 1528123102349-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Clemens Ladisch 2018-06-04 18:05:38 Re: psqlodbc driver issue with Win10 Update 1803
Previous Message Tobias Wendorff 2018-06-01 14:07:51 Re: NUMERIC type makes trouble in MS Access